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!
Bookmarks