Hello,
I am trying to assign unique numbers from 1-99 in column A by a formula for which the base should be unique and duplicate values in column B. Can you please help me with the formula? Value or Count? Below and attached I have already inserted in column A how I imagine it.
Also I would need to do the same but now in column C I have unique and duplicated values as well. I need to assign a number from 1 - 99 as I have showed attached.
Would you please inform how to do this?
A B A B C
1 123 1 123 11
1 123 2 123 12
2 124 3 124 13
3 125 4 125 14
4 126 5 126 15
5 127 6 127 16
5 127 6 127 16
5 127 7 127 17
EXCEL NR..JPG
Bookmarks