Closed Thread
Results 1 to 6 of 6

Fill data in sequence based on identifier

  1. #1
    Registered User
    Join Date
    12-26-2014
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    8

    Fill data in sequence based on identifier

    I am trying to fill data from one column to another in sequence based on the presence of an identifier in another column.

    Column A to be filled
    Data is in Column C
    Identifier is the number 1 in column B

    C1.xlsx
    Last edited by pitchin1; 12-26-2014 at 04:25 PM. Reason: PER REQUEST

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Fill data in sequence based on identifier

    images are pretty useless ,you cant work from an image
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. 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 shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    12-26-2014
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    8

    Re: Fill data in sequence based on identifier

    Sorry will the above work.. I realize this is most likely a simple function but I simply have very little excel experience. YOUR HELP IS APPRECIATED..

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Fill data in sequence based on identifier

    still not sure which cells are prefilled and which cells require a formula and i cant understand how the second table relates to the first

  5. #5
    Registered User
    Join Date
    12-26-2014
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    8

    Re: Fill data in sequence based on identifier

    Column A to be filled (needs a formula)

    Data is in Column C (prefilled)
    Identifier is the number 1 in column B (prefilled)

    I need a formula for column (A) The prefilled numbers that are in column (C) to column (A) in sequence based on the number 1 being present in column (B)

    The second table displays exactly how it should look when formulated properly.


    Here is a simple explanation: I need to fill column A with the data in column C but only in the rows that column B has the number 1 present.
    Last edited by pitchin1; 12-26-2014 at 05:34 PM.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,235

    Re: Fill data in sequence based on identifier

    Thread closed at OP's request - posted in CS forum
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Button to pull data from another area based on active cell as identifier
    By gotjobs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2014, 02:49 AM
  2. Auto fill decimal sequence using custom fill or formula
    By 8cats in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-22-2013, 08:53 AM
  3. Replies: 5
    Last Post: 04-13-2012, 10:50 PM
  4. Combine rows of data into 1 cell based on unique identifier
    By jud_goh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-11-2010, 05:06 PM
  5. Replies: 1
    Last Post: 12-07-2009, 07:02 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