Unique entries based on condition - count distinct
 

Hi,

I'm really struggling with what I thought should be easy.

A B C
D
branch salesperson transaction num Item code


I'm trying to the number of unique saples people in each branch, the number
of unique tranactions by each sales person, and the number of unique items
in each transaction.

In another program I use "Count Distinct" but am struggling to acheieve the
same in excel. Any ideas?

--
Rich
http://www.rhodes-lindos.co.uk
http://www.rhodes-pefkos.co.uk

Unique entries based on condition - count distinct
 

Try these array formulae

=SUM(N(FREQUENCY(IF(A1:A100="branch",MATCH(B1:B100 &"",B1:B100&"",0)),MATCH(B1:B100&"",B1:B100&"",0)) 0))

SUM(N(FREQUENCY(IF(B1:B100="salesperson",MATCH(C1: C100&"",C1:C100&"",0)),MATCH(C1:C100&"",C1:C100&"" ,0))0))

etc.

--

HTH

Bob

"Rich" wrote in message
...
Hi,

I'm really struggling with what I thought should be easy.

A B C D
branch salesperson transaction num Item code


I'm trying to the number of unique saples people in each branch, the
number of unique tranactions by each sales person, and the number of
unique items in each transaction.

In another program I use "Count Distinct" but am struggling to acheieve
the same in excel. Any ideas?

--
Rich
http://www.rhodes-lindos.co.uk
http://www.rhodes-pefkos.co.uk