Filling series column based on if condition

**RedWing** · 09-07-2011, 12:16 PM

Hi everyone,

My problem is the following.. :

Let's say I have the the cells A-01, A-02, A-03 in cells B1 to B3. If I drag down, Excel will autofill to A-04 A-05 etc..

What I want is an if condition, such that for example, if the cell adjacent to the series cell is blank, nothing is displayed, and if it is not blank, the series continues.

IF(A4="","",continue series)

It's easy enough to do this is if the series is just numerical, but because it contains letters, I can't just seem to do it using:

IF(A4="","",B3+1), for cell B4..etc.

Any help is appreciated.

Thanks!

**Cookstein2** · 09-07-2011, 12:29 PM

Please Login or Register  to view this content.

**Marcol** · 09-07-2011, 12:32 PM

One way
In B2 your starting code:= A-01

In B3

Please Login or Register  to view this content.

Drag/Fill Down

**RedWing** · 09-07-2011, 12:35 PM

Hi Cookstein,

That works wonderfully. Thanks a lot. I'm not quite sure how it works (reading up on the functions used..!). My only other question would then be, what if I had A-B-1, A-B-2, A-B-3 to sort; in which case the same formula gives a VALUE error.

Thanks again.

**RedWing** · 09-07-2011, 12:39 PM

Hi Marcol,

That works great too, thanks. My only remaining question is getting it to work with A-B-X, where X is a number and A and B can be a mixture, lets say... ABC-D35-X In which case your formula returns a partial fit.

**Marcol** · 09-07-2011, 01:56 PM

Hmm ... ?

That's maybe a bit more complicated, any formula whizz-kids around?

This should increment any single number in any given string

In B2 your starting code:= ABC-D35-X
In B3

Please Login or Register  to view this content.

**RedWing** · 09-07-2011, 02:12 PM

Wow, thanks, that is pretty complex.. but unfortunately I did not make myself very clear lol,

I meant in the sense that ABC-D35-X where X is 1
ABC-D35-1
ABC-D35-2
ABC-D35-3

etc. Anyway, I will try to work it out from the code you've given but feel free to chime in if you've still got the energy after making that code

Thanks!

**RedWing** · 09-07-2011, 02:23 PM

Actually I did a simple refinement of your existing code (for the A-01) and it works great. I will keep that more complex code for later. Thanks again guys.