Count unique visible records

  • Thread starter Thread starter doktorp
  • Start date Start date
D

doktorp

Hi,
I need to count the number of unique records in a filtered range. Any
help highly appreciated!
/drP
 
Doktorp said:
I need to count the number of unique records in a filtered range. Any
help highly appreciated!
Click to expand...

Filter using Data / Filter / Advanced Filter / Unique records only
Then a formula = SUBTOTAL(3,A2:A999) will give you the count of visible
rows between A2 and A999 (assuming there are no blank cells)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Many thanks,
is there any way of referring to this count in a formula, while still
showing the "not-unique" records.
I would like to see all records filtered (by one criteria/collumn), and
know how many of them are unique (in terms of another criteria/collumn)
 
Doktorp said:
is there any way of referring to this count in a formula, while still
showing the "not-unique" records.
I would like to see all records filtered (by one criteria/collumn), and
know how many of them are unique (in terms of another criteria/collumn)
Click to expand...

Easy to say - not easy to do.
30 minutes later and still no solution - I'm going to give up on this
one. Sorry.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
OK, I guess I'll have to work my way around it in some way. Lots of
thanks for trying, though!
/drP
 
Back
Top