Leftmost/Rightmost Cell

L

Lena

How can i get the value of the rightmost or the leftmost
cell from a specific row if the value is not empty ??

Thanks
Lena
 
F

Frank Kabel

Hi Lena
one way: Enter the following array formulas (entered with
CTRL+SHIFT+ENTER):
=INDEX(1:1,MAX(IF(1:1<>"",COLUMN(1:1))))
and
=INDEX(1:1,MIN(IF(1:1<>"",COLUMN(1:1))))
 
J

Jason Morin

To get the value furthest to the left in row 1:

=INDEX(1:1,MIN(IF(1:1<>"",COLUMN(1:1))))

Array-entered (meaning press ctrl/shift/enter).

Furthest to the right:

=INDEX(1:1,MAX(IF(1:1<>"",COLUMN(1:1))))

Also array-entered.

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional format question 6
Leftmost and Rightmost Cell 3
Start & End of the data series 0
How do I reference contents of a cell at the bottom of a column? 2
Next-To-Last, Non-Blank, Rightmost Value in a Row 6
How do I lookup a table from right to left ? 1
Table exceeds width of page, unable to correct it ! 1
Finding the rightmost occupied cell 7

Top