+ Reply to Thread
Results 1 to 5 of 5

Consecutively numbered cells based on a title column and number of cells with that title

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    Emeryville, CA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Consecutively numbered cells based on a title column and number of cells with that title

    So that title is confusing..

    I have one column with titles and a second with the number of unique id's with that title.

    So if the title cell reads "Customer" and the number cell reads "300", I want to create a new column with 300 cells containing "Customer 1"... all the way to "Customer 300"

    The problem is I have 1000 entries in my title and number columns and I want to convert these into one column with 25000 uniquely id'd cells.

    I imagine someone could write a macro to do this but that is something I do not know how to do. Any help would be much appreciated.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,508

    Re: Consecutively numbered cells based on a title column and number of cells with that tit

    Post a sample workbook with just a few rows of data and I'll show you how you could do it with a few formulae.

    Pete

  3. #3
    Registered User
    Join Date
    08-03-2012
    Location
    Emeryville, CA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Consecutively numbered cells based on a title column and number of cells with that tit

    How can I automate that process?? Thanks!
    Attached Files Attached Files
    Last edited by kimjongphil; 10-18-2012 at 09:35 PM.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,508

    Re: Consecutively numbered cells based on a title column and number of cells with that tit

    In your example file, I've put 0 in C3 (important) and this formula in C4:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    which is then copied down beyond your data.

    Then I have this formula in D4:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    which is then copied down until you get blanks.

    Hope this helps.

    Pete
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-03-2012
    Location
    Emeryville, CA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Consecutively numbered cells based on a title column and number of cells with that tit

    Thank You Pete! This is a very neat little bit of logic. Your help is much appreciated

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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