D
Dean
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.
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.