Formula to find cell with data on a row

[Guest]

Hello from Steved

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

Thankyou.

 

[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))

 

[Biff]

Hi!

What do want, the cell's address?

Biff

 

[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)

 

[Guest]

Thanks 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))

 

[Max]

You're welcome, Steved.