Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Unique Records
I have the following table (Excel 2007)
Month Broker # December 32350 December 32350 December 24715 January 24715 January 24715 January 44063 (table is a1:b7) I want to search for a month and then count the unique records in column B. So for the month of January, it would return 2 since one of the 3 records is a duplicate. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
Count unique records... with a twist... Need help! | Excel Worksheet Functions | |||
Count the number of unique records | Excel Worksheet Functions |