| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting unique values
I am trying to count the number of unique values in my data. Here is an
example: 589450 589451 589452 589453 589454 589455 589455 589455 589455 Ideally I want to know that the count for the first 5 values will be 1, but also the count of 4 for the last four values, such as: 589450 1 589451 1 589452 1 589453 1 589454 1 589455 4 I have tried VLOOKUP, advanced filters, and COUNTIF, but I get the following result: 589450 1 589451 1 589452 1 589453 1 589454 1 589455 4 589455 4 589455 4 589455 4 I have over 19,000 values that I need to count in this way so duplicates as seen above in the last example are not desirable. Any help would be greatly appreciated, and many thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting unique values | Excel Discussion (Misc queries) | |||
| Counting Unique Values | Excel Discussion (Misc queries) | |||
| Counting unique values | Excel Discussion (Misc queries) | |||
| Counting unique values | Excel Worksheet Functions | |||
| Counting Unique Values | Excel Worksheet Functions | |||
Threaded Mode
