Find duplicates and number them.
Solved
Emmy-lo
-
Emmy-lo -
Emmy-lo -
Hello,
I just got a tricky question at work and I can't seem to find the solution.
I can only count the duplicates using 'COUNTIFS', but I would like to number them.
To explain, in column A there are different numbers that sometimes appear multiple times, so I would like to identify these duplicates and automatically number them in order.
For example, '57' appears 4 times in the list (though not consecutively), how can I automatically have '1', '2', '3', and '4' appear in column B?
Maybe it's not possible.
In any case, thank you for considering my request!
Best regards,
Emmy
Configuration: Windows / Firefox 60.0
I just got a tricky question at work and I can't seem to find the solution.
I can only count the duplicates using 'COUNTIFS', but I would like to number them.
To explain, in column A there are different numbers that sometimes appear multiple times, so I would like to identify these duplicates and automatically number them in order.
For example, '57' appears 4 times in the list (though not consecutively), how can I automatically have '1', '2', '3', and '4' appear in column B?
Maybe it's not possible.
In any case, thank you for considering my request!
Best regards,
Emmy
Configuration: Windows / Firefox 60.0
2 answers
-
Hello Emmy
One way to number the duplicates and know the count of each type:
In B2 enter the formula: = COUNTIF($A$1:A1, A1)"/"&COUNTIF(A:A, A1) and drag it down the column
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein -
Hello,
Put this formula in B1 and drag it down:
=IF(COUNTIF($A$1:A1,A1)>1,COUNTIF($A$1:A1,A1)-1,"")
Daniel
