| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Unique Values in a entire column, not just range
Howdy All,
I have a formula: =Sum(IF(Frequency(Match(A1:A14000,A1:A14000,0),Mat ch(A1:A14000,A1:A14000,0))0,1)) Which will give me a count if the unique values in the in column A, Rows 1 through 14000. What I need is a formula I can use to count the unique values in and entire Column, A:A. The above formula does not seem to allow that. Any ideas are greatly appreciated. Thanks, Brian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count number of unique values in column | Excel Worksheet Functions | |||
| count unique values in a filtered range | Excel Worksheet Functions | |||
| count of unique values within a column | Excel Discussion (Misc queries) | |||
| How do I count unique values within a date range? | Excel Discussion (Misc queries) | |||
| Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) | |||
Threaded Mode
