View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yhtak
 
Posts: n/a
Default Counting unique records

No, I havent... sadly I have v. limited knowledge of pivot tables.

"Barb Reinhardt" wrote:

You can do this with a pivot table. Have you tried that?

"yhtak" wrote:

I am trying to count unique entries in one filtered column of a multi column,
multi-row spreadsheet. Is this possible? e.g.


872T56OM17
872T56OM17
872T56OH17
etc
etc
(up to 26K rows)
Thanks is advance