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