| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Unique Values
I only do that when I'm bored and there's nothing to play with!
Biff "JMB" wrote in message ... Don't tell me, I know - the 1 is superfluous <g. "Biff" wrote: Try this: =SUMPRODUCT(--(A1:A9<"")/COUNTIF(A1:A9,A1:A9&"")) Biff "bob" wrote in message ... I have a column with the following dates: 11/23/05 11/23/05 11/23/05 11/25/05 11/25/05 11/28/05 12/1/05 12/1/05 12/1/05 I want a formula that will tell me how many unique dates there are in the column. Can anyone help? thanks, Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique values with criteria | Excel Worksheet Functions | |||
| list unique values in a column | Excel Worksheet Functions | |||
| Populate combo box with unique values only | Excel Discussion (Misc queries) | |||
| Counting Values | Excel Worksheet Functions | |||
| Counting unique values + frequency | Excel Worksheet Functions | |||
Threaded Mode
