Thank you so much guys!! I feel embarrased that it took me the whole morning
to do it manually and 1 minute to do it using the formula! I'll be using
this formula quite a bit! I tried both but for some reason only T. Valko's
formula worked.
Thanks again!
Fatima

"T. Valko" wrote:

Assuming there are no empty cells in the document range.

Try this array formula** :

=COUNT(1/FREQUENCY(IF(A2:A10="Joe",B2:B10),B2:B10))

Or, use cells to hold the name:

D2 = Joe
D3 = Paul

=COUNT(1/FREQUENCY(IF(A$2:A$10=D2,B$2:B$10),B$2:B$10))

Then copy down as needed.


** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"fsfiligoi" wrote in message
...
I need some help from the experts! I'm trying to count how many documents
each employee created using this info:
Name Doc #
Joe 20
Joe 21
Joe 21
Joe 21
Paul 34
Paul 34
Paul 35
Paul 35
Paul 36
The result here would be: Joe created 2 documents and Paul created 3
documents.
How could I do it? I can't use filter because I have a lot of data.