# Fill empty cells per adjacent column

1. ## 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

2. ## Re: Fill empty cells per adjacent column

Hi,

In C1 and copied down

``Please Login or Register  to view this content.``
Rgds

3. ## 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. ## 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.

5. ## 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. ## Re: Fill empty cells per adjacent column

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. ## 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. ## 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. ## 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. ## 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. ## 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. ## Re: Fill empty cells per adjacent column

Done.

Thanks for explaining.

#### Thread Information

##### Users Browsing this Thread

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

#### 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