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
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
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
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
>
> --
>
> --
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
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
Since you're using Excel2007,
The simplest way (in my opinion) would be to use
=countifs
in Cell F7 use:
=COUNTIFS($A:$A,$E7,$C:$C,F$6)
(if you use the "anchors" ($) properly, you'll be able to drag the
formula across and down for other products)
If you want more assistance with it,
try using
