+ Reply to Thread
Results 1 to 2 of 2

Auto Populating a cell based on values from another cell

  1. #1
    Registered User
    Join Date
    05-12-2011
    Location
    Los Angeles
    MS-Off Ver
    Excel 2007
    Posts
    1

    Arrow Auto Populating a cell based on values from another cell

    Hi,
    1st.
    Got Column A which contains part numbers (only numbers). (starting from A3)
    Got Column G which also contains part numbers (only numbers) (starting from G3)

    2nd.
    There are times where Column A can have more or less part numbers than Column G and VS.

    3rd
    I like a formula that can auto generate a numerical fill-in List in Column F depending on how ever many part numbers are found in either Column A and or Column G

    4th
    I like this auto fill-in of numerical numbers starting from 1 to be based on which ever Column A or G has the longest list of part numbers.

    Example

    A3 F3 G3
    75895 1 6575
    3562 2 9867
    46598 3 1444
    85687 4
    ...........................................

    as you see all I need is for column F to be auto populated by a numerical list starting from 1 and to continue depending on how long eighther Colum A or G are.

    Thank you

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Auto Populating a cell based on values from another cell

    Hi Isin,

    In F3 you can try this formula:

    =IF(AND(A3="",G3=""),"",ROW(A1))

    Fill that down beyond your last row of data. Any row in which both A3 and G3 are blank, the formula will not show a number. This assumes you don't have any gaps in your lists in column A or G.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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