Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steved
 
Posts: n/a
Default 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   Report Post  
Max
 
Posts: n/a
Default

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   Report Post  
Biff
 
Posts: n/a
Default

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   Report Post  
Max
 
Posts: n/a
Default

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   Report Post  
Steved
 
Posts: n/a
Default

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   Report Post  
Max
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Using data in cell for a formula Scott Excel Worksheet Functions 2 May 26th 05 09:03 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Splitting Data in a Cell Newbie1092 Excel Worksheet Functions 3 May 10th 05 05:48 PM
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"