ExcelBanter - Unique Records Count with AutoFilter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Unique Records Count with AutoFilter (https://www.excelbanter.com/excel-worksheet-functions/187843-unique-records-count-autofilter.html)

Danni2004

Unique Records Count with AutoFilter

Im trying to set up a formula that will give me a count of unique records
and adjusts with autofilter the way that subtotal does.
Here is an example of my data:
A B C
1 Region Weekday PersonID
2 1 TUES 119718
3 3 TUES 76826
4 2 TUES 165236
5 3 WED 89163
6 1 WED 119718
7 3 WED 76826
8 3 THURS 89163
9 1 THURS 119718
10 3 THURS 76826
11 2 THURS 165236

Danni2004

Unique Records Count with AutoFilter

Also, please note - unable to use Pivot Tables for this worksheet

"Danni2004" wrote:

Im trying to set up a formula that will give me a count of unique records
and adjusts with autofilter the way that subtotal does.
Here is an example of my data:
A B C
1 Region Weekday PersonID
2 1 TUES 119718
3 3 TUES 76826
4 2 TUES 165236
5 3 WED 89163
6 1 WED 119718
7 3 WED 76826
8 3 THURS 89163
9 1 THURS 119718
10 3 THURS 76826
11 2 THURS 165236

All times are GMT +1. The time now is 03:56 PM.