Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 ---- |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Using data in cell for a formula | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Splitting Data in a Cell | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel |