Posted to microsoft.public.excel.misc

fsfiligoi

external usenet poster

Posts: 15

Count unique values

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count unique values, if ...	Averitt Engineer[_2_]	Excel Worksheet Functions	2	February 15th 07 06:41 PM
Count unique values	Mary	Excel Worksheet Functions	3	January 20th 06 08:56 PM
Count of Unique values	Richard	Excel Worksheet Functions	3	September 27th 05 05:46 AM
Count unique values and create list based on these values	vipa2000	Excel Worksheet Functions	7	August 5th 05 01:17 AM
Count Unique Values	annie	Excel Worksheet Functions	1	June 9th 05 07:19 AM

All times are GMT +1. The time now is 11:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us