Find the first blank cell in a row

[dwayne]

I have a table which is 35 columns wide (A-AI). In column
A, I need to have a formula that indicates the column
number containing the first blank cell in that row. To
add to the confusion, I need column F to be where the
blank cell is indexed from.

Example:

A B C D E F G

1 4 X X X
2 2 X
3 5 X X X X

In the above example, column C is where the blank cell is
indexed from.

In the first row, 4 is shown in column A because the first
blank cell is 4 cells to the left.

Is there a way this can be done?

Thanks,
Dwayne

 

[Bob Phillips]

Dwayne,

Similar to the previous reply

=MATCH(TRUE,ISBLANK(C1:AK1),0)

it is an array formula, so enter with Ctrl-Shift-Enter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi dwayne

assuming that after the first blank cell no other filled cell exist you
can use COUNTA. e.g. for A1
=COUNTA(B1:AI1)-1

i have to admit that i did not unterstand your second question
regarding column F. Maybe you can give some more details

Frank

 

[Peo Sjoblom]

One way

=MATCH(TRUE,$C2:$I2="",0)

entered with ctrl + shift & enter
adapt to fit the ranges

 

[Peo Sjoblom]

Note that if the values (however unlikely) are derived from formulas,
isblank won't work..