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

Hi,

In C1 and copied down

=IF(A1="",C2,A1)

Rgds

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.

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.

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

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

Regards