Find the first blank cell in a row

  • Thread starter Thread starter dwayne
  • Start date Start date
D

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
 
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)
 
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
 
One way

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

entered with ctrl + shift & enter
adapt to fit the ranges
 
Note that if the values (however unlikely) are derived from formulas,
isblank won't work..
 
Back
Top