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