It looks like this formula works only with numbers. If I have duplicate text
or a dates instead of document numbers, do you know what I should to change
to make it work?
Am I asking too much now? : )

"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.