Enumerate repeated items in a list
Hi guys,
I have a 130k lines file with a several unique ID's in column "C", and I would like you to help me to know how can I enumerate each of them. For Example, code K0001 is repeated 29 times in the whole list, and I need to enumerate from 1 to 29.
I hope that I've explained well the idea.
Thanks for your help and time
Best regards
How is this different from the thread yesterday and could you post a sample Excel file. Not a picture please, because we cannot work with picture.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
HTH
Regards, Jeff
Thanks Jeffrey
I attached a file with the Before/After simple example. I have blanks cell in the list too.
As you can see, for example, the code K001 is repeated 5 times, and the fill should be from 1 to 5 in ascendent order.
Let me know if my english or excel example sucks xD lol
Thanks..!
Greetings
In C2 copied down...
=COUNTIF($A$2:A2,A2)
Note: If you want to hide the zero's without doing it within the formula...
Hide Zero’s
- Highlight range >> Ctrl + 1 >> Number tab >> Category: Custom >> Type: 0;;;@
- Office Button >> Excel Options >> Advanced >> Display Options for this worksheet: Uncheck Show as zero
If within the formula...
=IF(COUNTIF($A$2:A2,A2),COUNTIF($A$2:A2,A2),"")
Last edited by jeffreybrown; 07-19-2013 at 11:55 AM.
I was using the same formula, but I didn't put the $ to the first range..!
Thanks Jeffrey, again, thanks..!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks