| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Unique Values
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Shane Goodman" wrote in message ... Biff, It worked! I have trouble understanding anything nested three or more times, so I just copies it exactly and replaced the range values. Thanks for your help. Shane. "T. Valko" wrote in message ... Try this array formula** : =COUNT(1/FREQUENCY(IF(A2:A10<"",IF(B2:B10<"",MATCH(B2:B10 ,B2:B10,0))),ROW(B2:B10)-MIN(ROW(B2:B10)+1))) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count unique values | Excel Discussion (Misc queries) | |||
| How to count unique values? | Excel Worksheet Functions | |||
| Count of Unique values | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| Count Unique Values | Excel Worksheet Functions | |||
Threaded Mode
