Posted to microsoft.public.excel.worksheet.functions

Danni2004

external usenet poster

Posts: 26

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Unique Records	Jon Dow[_2_]	Excel Worksheet Functions	4	February 26th 07 05:28 AM
Count Unique records based on the Criteria in another colum	Rajat	Excel Worksheet Functions	0	November 30th 06 03:43 AM
Count Unique records based on the Criteria in another colum	Ron Coderre	Excel Worksheet Functions	0	November 29th 06 06:28 PM
Count unique records... with a twist... Need help!	[email protected]	Excel Worksheet Functions	4	August 3rd 06 06:17 PM
Count the number of unique records	[email protected]	Excel Worksheet Functions	7	March 8th 06 07:33 AM

All times are GMT +1. The time now is 09:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us