Hi all
I have raw data in which colA has codes like XY123,this codes are random and will have duplicateS what I do is with countif I take a count of each code. In ColB of code count will have 1's ,2's,3's .....so on what I want is for example if 1's are ten in ColB then in colC A B C A B C A B C A next is 2's then B B C C A A B B ....next 3's C C C .....like this i have to do everyday 12000 rows.please help me how to a vba program thanks in advance.{A,B,C}
Bookmarks