Count
You can count the individuals with
=SUMPRODUCT(--(B1:B100<""),1/(COUNTIF(B1:B100,B1:B100&""))
--
HTH
Bob
"Louja" wrote in message
...
Hi,
On my file I get a list of accounts. I have a look up which lets me
know which account belongs to which individual.
I need to know how many different individuals there are each day.
There can be a lot of change with new accounts etc so was thinking of
doing a pivot table and somehow using a COUNT function but am not sure
if this is going to work or if there is a better alternative.
Thanks
Louisa
|