Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

2011-01-06 Thread Mao
en BP Name is not repeated in more than 1 Depot (as in your > sample data) > If either of the above limitations are unacceptable, then it's back to the > drawing board. > Regards - Dave. > > Date: Thu, 6 Jan 2011 18:40:43 +0530 > Subject: Re: $$Excel-Macros$$ How to count

RE: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

2011-01-06 Thread Dave Bonallack
o the drawing board. Regards - Dave. Date: Thu, 6 Jan 2011 18:40:43 +0530 Subject: Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria From: kalx...@gmail.com To: excel-macros@googlegroups.com CC: jainayus...@gmail.com; schreiner_p...@att.net exactly Ayush, I

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

2011-01-06 Thread Kal xcel
exactly Ayush, I have already tried Paul's solution but I didn't get desired result. I am attaching the file again with expected result Please help Thanks in advance Kalyan On Thu, Jan 6, 2011 at 6:13 PM, Ayush wrote: > Right Paul, but your formula is counting duplicate values also.This user

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

2011-01-06 Thread NOORAIN ANSARI
Dear Kalyan, Please find see attachment... Thanks, Noorain Ansari On Thu, Jan 6, 2011 at 4:43 AM, Ayush wrote: > Right Paul, but your formula is counting duplicate values also.This user > need to count only distinct values. correct ? > > Best Regards, > Ayush Jain > > -- > > --

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

2011-01-06 Thread Paul Schreiner
Paul ________________ From: Ayush To: excel-macros@googlegroups.com Sent: Thu, January 6, 2011 7:43:46 AM Subject: Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

2011-01-06 Thread Ayush
Right Paul, but your formula is counting duplicate values also.This user need to count only distinct values. correct ? Best Regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ How to count distinct values on the base of multiple criteria

2011-01-06 Thread Paul Schreiner
acros$$ How to count distinct values on the base of multiple criteria Dear experts, I have attached a file with query. Please help on that Thanks in advance Kalyan -- -- Some important links for excel users: 1. Foll

$$Excel-Macros$$ How to count distinct values on the base of multiple criteria

2011-01-06 Thread Kal xcel
Dear experts, I have attached a file with query. Please help on that Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exce