Formula to find cell with data on a row
 

Hello from Steved

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

Thankyou.

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))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Steved" wrote in message
...
Hello from Steved

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

Thankyou.

Hi!

What do want, the cell's address?

Biff

"Steved" wrote in message
...
Hello from Steved

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

Thankyou.

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)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Thanks Max

"Max" wrote:

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))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Steved" wrote in message
...
Hello from Steved

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

Thankyou.

You're welcome, Steved.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Steved" wrote in message
...
Thanks Max