| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting the number of unique values within a range
I would be most grateful if someone could offer me some help.
I need to count the number of unique values within a column range. Each value consists of a series of alpha and numberical characters. I have used the formula below but it keeps crashing my spreadsheet: =SUMPRODUCT((1/COUNTIF(A1:A5,A1:A5&""))) Any help or advice would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique values in a row | New Users to Excel | |||
| Counting Unique Values by Date Range | Excel Worksheet Functions | |||
| Counting Unique Values | Excel Discussion (Misc queries) | |||
| Counting unique text/number cells from a range | Excel Discussion (Misc queries) | |||
| Counting unique text/number cells from a range | Excel Worksheet Functions | |||
Threaded Mode
