Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count unique visible records
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count unique visible records
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count unique visible records
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count unique visible records
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count unique visible records
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique Records | Excel Worksheet Functions | |||
count unique records | Excel Worksheet Functions | |||
Count Unique Records | New Users to Excel | |||
pivot count unique records only | Excel Discussion (Misc queries) | |||
Count Unique Records | Excel Worksheet Functions |