| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count unique entries...
Could anyone please help me with a formula that would count how many
unique entries are in a given range of cells. All I need to know is how many different entries there are. (Not including empty cells) So if I have A2:A20, A2 Hello A3 Goodbye A4 Hello A5 Cya A6 L8R A7 Hello A8 Goodbye and so on and so on...I want a formula to tell me that there are 4 different entries. Any help would be great! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique entries based on given condition | Excel Discussion (Misc queries) | |||
| count and display unique values | Excel Worksheet Functions | |||
| counting unique entries in a list | Excel Discussion (Misc queries) | |||
| how to count unique entries with multiple condition | Excel Worksheet Functions | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Threaded Mode
