Formula to find cell with data on a row

S

Steved

Hello from Steved

Please what formula would find the first cell in a row with data or value in
it.

Thankyou.
 
M

Max

Perhaps one way ..

Assuming it's for row1, and "first cell in a row" means from the left

Put in say, A2, and array-enter
(press CTRL+SHIFT+ENTER):

=INDEX(1:1,MATCH(TRUE,1:1<>"",0))
 
M

Max

If you want the cell address (relative),

Put in say, A2, and array-enter
(press CTRL+SHIFT+ENTER):
=ADDRESS(ROW(1:1),MATCH(TRUE,1:1<>"",0),4)
 
S

Steved

Thanks Max

Max said:
Perhaps one way ..

Assuming it's for row1, and "first cell in a row" means from the left

Put in say, A2, and array-enter
(press CTRL+SHIFT+ENTER):

=INDEX(1:1,MATCH(TRUE,1:1<>"",0))
Click to expand...
 
Top