+ Reply to Thread
Results 1 to 4 of 4

creating a sequential number based on the content of another cell

  1. #1
    Registered User
    Join Date
    12-17-2009
    Location
    Kirkcaldy, Scotland
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2201) 64-bit
    Posts
    75

    creating a sequential number based on the content of another cell

    I am wanting to create a new product ID based on the contents of another cell in the sheet - see example for what I need to do - basically a product ID (starting at 4214) needs to be allocated to the items based on the number in Column C - so where the same number is shown in column C then the same product ID would show. Each time the number in column C changes then the new product ID increases by one.

    Any suggestions (the simpler the better) would be appreciated.

    In the sample spreadsheet I have duplicated the data (columns A-D) in columns G-J to show how I want the data to show when the formula is run.

    Hope that makes sense. Fingers crossed someone can help as otherwise I will need to do this manually on a rather large spreadsheet which will likely incur one or two errors.
    Attached Files Attached Files

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

    Re: creating a sequential number based on the content of another cell

    Put your starting value (4214) in cell A2, and then you can use this formula in A3:

    =IFERROR(INDEX(A$2:A2,MATCH(C3,C$2:C2,0)),MAX(A$2:A2)+1)

    Copy this down as far as you need to.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    12-17-2009
    Location
    Kirkcaldy, Scotland
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2201) 64-bit
    Posts
    75

    Re: creating a sequential number based on the content of another cell

    Thanks Pete that is absolutely perfect - spot on thanks!

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

    Re: creating a sequential number based on the content of another cell

    Glad to help - thanks for the rep.

    Pete

+ 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: 3
    Last Post: 07-15-2016, 06:45 AM
  2. [SOLVED] Creating new rows based on cell content
    By natonato in forum Excel General
    Replies: 2
    Last Post: 06-11-2015, 09:18 PM
  3. creating sequential number with text prefix
    By j_r_m_c in forum Excel General
    Replies: 3
    Last Post: 07-04-2014, 09:42 AM
  4. [SOLVED] Creating a certain number of entries based on a number in a cell
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM
  5. Creating a certain number of entries based on a number in a cell
    By PPV in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. [SOLVED] Creating a certain number of entries based on a number in a cell
    By PPV in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] Creating a certain number of entries based on a number in a cell
    By PPV in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Tags for this Thread

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