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


---
Message posted from http://www.ExcelForum.com/

Doktorp wrote:
> I need to count the number of unique records in a filtered range. Any
> help highly appreciated!
>

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)


---
Message posted from http://www.ExcelForum.com/

Doktorp wrote:
> 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)
>

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


---
Message posted from http://www.ExcelForum.com/