How do I choose the last nonblank cell in a ROW?
 

I have a row of sales data by month. I need to create a link in a seperate
worksheet to access the last data in the row. The link must differenate
between 0 as data and a blank cell as no data.

How do I choose the last nonblank cell in a ROW?
 

Hi,

This returns the last populated cell in row 2 of sheet 1

=LOOKUP(2,1/(Sheet1!2:20),Sheet1!2:2)

Mike

"DaChris" wrote:

I have a row of sales data by month. I need to create a link in a seperate
worksheet to access the last data in the row. The link must differenate
between 0 as data and a blank cell as no data.

How do I choose the last nonblank cell in a ROW?
 

Something like this array* formula will work.

=OFFSET(A2,0,MIN(IF(ISBLANK(2:2),COLUMN(2:2)))-2)

*Confirm formula using Ctrl+Shift+Enter, not just Enter.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"DaChris" wrote:

I have a row of sales data by month. I need to create a link in a seperate
worksheet to access the last data in the row. The link must differenate
between 0 as data and a blank cell as no data.

How do I choose the last nonblank cell in a ROW?
 

Hi,

My previous post reyturns the lat populated cell text or numeric. For
numeric on try

=LOOKUP(6.022*10^23,Sheet1!2:2)

Mike
"Mike H" wrote:

Hi,

This returns the last populated cell in row 2 of sheet 1

=LOOKUP(2,1/(Sheet1!2:20),Sheet1!2:2)

Mike

"DaChris" wrote:

I have a row of sales data by month. I need to create a link in a seperate
worksheet to access the last data in the row. The link must differenate
between 0 as data and a blank cell as no data.