+ Reply to Thread
Results 1 to 12 of 12

Fill empty cells per adjacent column

  1. #1
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Fill empty cells per adjacent column

    Hi,

    In the attached WB column "A" has the raw data.

    I want column "C" to be filled as shown.

    There is no consistence pattern, in column "A", and the Manufacturers cannot be Alphabetical sorted.

    Thanks, Elm
    Attached Files Attached Files
    Last edited by ElmerS; 10-19-2010 at 01:34 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Fill empty cells per adjacent column

    Hi,

    In C1 and copied down

    Please Login or Register  to view this content.
    Rgds
    Last edited by Richard Buttrey; 10-19-2010 at 12:52 PM.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Fill empty cells per adjacent column

    Thank you but if it was that easy & simple even a newbie like me would know the solution.

    I wrote (quote): "I want column "C" to be filled as shown" and this means that column "C" does not exist, yet, and the formula I'm looking for will fill C1:C20 as I typed by hand.

    To emphasize - column"C" is not a part of the raw data.

    I'm looking for a formula which will refer to column "A" and fill column "C" as shown.

    Elm

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Fill empty cells per adjacent column

    The formula you were given will work it just works bottom up rather than top down - once C1 is copied to C6 etc you will get answers in C1:C5.

    Please do not be so arrogant as to presume you have all the answers Elm and need not test - if you did you would not be here.

    If you wish to calculate always top down then you're left with something like:

    {=IF(LEN(A1),A1,INDEX($A2:$A$21,MATCH(TRUE,$A2:$A$21<>"",0)))}

    but given convention is not important to you I suggest you persevere with Richard's suggestion.
    Last edited by DonkeyOte; 10-19-2010 at 01:12 PM. Reason: typo

  5. #5
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Fill empty cells per adjacent column

    Thanks for the formula but not for the lecture.

    Why do you think I was arrogant ?
    Where did I wrote I have all the answers ?

    When column "C" is empty and waiting to be filled by a formula, and this was very clear from my question, no formula will work if it is referred to column "C" (and I don't mean referring to something like ROW(C1) etc.

    Didn't I wrote that I'm a newbie ?
    Does this points as being arrogant ?

    Elm

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Fill empty cells per adjacent column

    Quote Originally Posted by Elm
    Why do you think I was arrogant ?
    I won't get into a debate with you Elm. Perhaps I misinterpreted ? The fact some very good people on this board see fit to simply ignore your posts would imply otherwise.

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Fill empty cells per adjacent column

    Hi,

    Have you actually tried the solution I gave you in C1 and copied down.

    It does exactly what you want and is simple. I know column C doesn't yet exist that's why you're entering the formula in C1 and down.

    I'm somewhat perplexed at your self-description as a newbie. We normally expect that to apply to some with a mere handful of posts and not the hundreds that you have logged.

    Regards

  8. #8
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Fill empty cells per adjacent column

    Well, I apologize and my previous reply proves my being a newbie by not understanding your formula.

    All my posts were mostly, if not all, questions and it will take me a lot more time to became more than a newbie.

    Thanks, Elm

  9. #9
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Fill empty cells per adjacent column

    OK, glad my response was of some use after you had understood it. If you have an opportunity then please rate it appropriately.

    Regards

  10. #10
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Fill empty cells per adjacent column

    I'm not familiar with rating a response/solution.

    I, usually, mark a thread as SOLVED.

    Could you instruct me.

    Elm

  11. #11
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Fill empty cells per adjacent column

    Hi,

    Above every post over on the right hand side there are some icons. Look for a blue set of weighing scales. If you hover over them you'll see it says something like 'Add to n's reputation'

    Click this icon and add a comment if you wish. It's nothing to do with solving a post but whether you want to show your appreciation.

    Rgds

  12. #12
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Fill empty cells per adjacent column

    Done.

    Thanks for explaining.

+ 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