+ Reply to Thread
Results 1 to 5 of 5

Enumerate repeated items in a list

  1. #1
    Registered User
    Join Date
    07-18-2013
    Location
    Santiago, Chile
    MS-Off Ver
    Excel 2007
    Posts
    7

    Question 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. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    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
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    07-18-2013
    Location
    Santiago, Chile
    MS-Off Ver
    Excel 2007
    Posts
    7

    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
    Attached Files Attached Files

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,084

    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),"")
    Last edited by jeffreybrown; 07-19-2013 at 11:55 AM.

  5. #5
    Registered User
    Join Date
    07-18-2013
    Location
    Santiago, Chile
    MS-Off Ver
    Excel 2007
    Posts
    7

    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..!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 06-21-2013, 04:35 PM
  2. Replies: 3
    Last Post: 08-13-2012, 04:47 PM
  3. [SOLVED] Calculate average price of repeated items in list
    By watney971 in forum Excel General
    Replies: 3
    Last Post: 03-28-2012, 11:04 AM
  4. How to count items that are not repeated in one row?
    By Lewis Koh in forum Excel General
    Replies: 2
    Last Post: 04-24-2011, 11:07 PM
  5. Enumerate form items
    By Kurt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-28-2005, 06:05 PM

Bookmarks

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