Counting Uniques

[psycoperl]

Hi, I have a worksheet in Excel that is a log of transactions (after we run a process, we paste the log information at the bottom to maintain all history) What I would like to be able to find out and include in a separate worksheet in the same workbook file, is how many Unique end users did we service? A simple count would not help as we could have multiple transactions for the same person.

Is there a Count Unique function or some other method to achieve this?

 

[Aladin Akyurek]

That does it & way quicker than my attempt.
Cheers

Here is a link on performance:https://www.mrexcel.com/forum/excel-questions/292473-performance-formulas-unique-count.html