# Count unique visible records

doktorp
Guest
Posts: n/a

 12th Dec 2003
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/

Bill Manville
Guest
Posts: n/a

 13th Dec 2003
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

doktorp
Guest
Posts: n/a

 15th Dec 2003
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/

Bill Manville
Guest
Posts: n/a

 16th Dec 2003
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

doktorp
Guest
Posts: n/a

 16th Dec 2003
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/

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Vette66 Microsoft Excel Worksheet Functions 1 9th Oct 2004 06:44 PM Vette66 Microsoft Excel Worksheet Functions 1 8th Oct 2004 09:54 PM Vette66 Microsoft Excel Worksheet Functions 1 8th Oct 2004 08:08 PM Vette66 Microsoft Excel Worksheet Functions 1 8th Oct 2004 04:57 PM Vette66 Microsoft Excel Worksheet Functions 2 8th Oct 2004 04:45 PM

Features