Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-19 Thread Vaibhav Joshi
Cheers!! On Thu, Jun 19, 2014 at 4:03 PM, SG wrote: > Thankyou so much Vabz > > > On Wednesday, June 18, 2014 8:50:04 PM UTC+5:30, Vabz wrote: > >> Chek this,,, >> >> >> On Wed, Jun 18, 2014 at 7:08 PM, SG wrote: >> >>> yeah got it...one more thing..in reports, we can't say customer to >>>

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-19 Thread SG
Thankyou so much Vabz On Wednesday, June 18, 2014 8:50:04 PM UTC+5:30, Vabz wrote: > > Chek this,,, > > > On Wed, Jun 18, 2014 at 7:08 PM, SG > > wrote: > >> yeah got it...one more thing..in reports, we can't say customer to select >> * for "All" because it's not user friendly. What to do in

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread Vaibhav Joshi
Chek this,,, On Wed, Jun 18, 2014 at 7:08 PM, SG wrote: > yeah got it...one more thing..in reports, we can't say customer to select > * for "All" because it's not user friendly. What to do in that case?? > > > On Wednesday, June 18, 2014 6:53:29 PM UTC+5:30, Vabz wrote: > >> when you say "ALL",

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread SG
yeah got it...one more thing..in reports, we can't say customer to select * for "All" because it's not user friendly. What to do in that case?? On Wednesday, June 18, 2014 6:53:29 PM UTC+5:30, Vabz wrote: > > when you say "ALL", for excel / computer it is * (asterik), remember old > days when DO

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread Vaibhav Joshi
when you say "ALL", for excel / computer it is * (asterik), remember old days when DOS were used & where command was Dir *.* Cheers!! On Wed, Jun 18, 2014 at 6:48 PM, SG wrote: > Amazing Vabz...thanksss..Can you please explain the idea behind this??? > > > On Wednesday, June 18, 2014 6:30:28

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread SG
Amazing Vabz...thanksss..Can you please explain the idea behind this??? On Wednesday, June 18, 2014 6:30:28 PM UTC+5:30, Vabz wrote: > > Hi > > In cell C2 put * (only asterik) instead of ALL. > > Cheers!! > > > On Wed, Jun 18, 2014 at 6:10 PM, SG > > wrote: > >> >> Hi Experts, >> >> I'm looking f

Re: $$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread Vaibhav Joshi
Hi In cell C2 put * (only asterik) instead of ALL. Cheers!! On Wed, Jun 18, 2014 at 6:10 PM, SG wrote: > > Hi Experts, > > I'm looking for a solution to summarise the data based on multiple > criterias in drop downs. My data has 3 dropdowns.I have tried it using > advance filter > but it fai

$$Excel-Macros$$ Summarise data based on multiple combination of criterias

2014-06-18 Thread SG
Hi Experts, I'm looking for a solution to summarise the data based on multiple criterias in drop downs. My data has 3 dropdowns.I have tried it using advance filter but it fails when all criterias selected as "All". The problem starts when any of the dropdown is selected as "All" .I'm unable