# Enumerate repeated items in a list

1. ## 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

2. ## Re: Enumerate repeated items in a list

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

3. ## Re: Enumerate repeated items in a list

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

4. ## Re: Enumerate repeated items in a list

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),"")

5. ## Re: Enumerate repeated items in a list

I was using the same formula, but I didn't put the \$ to the first range..!

Thanks Jeffrey, again, thanks..!!!

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1