Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking uprange for next nonblank cell | Excel Discussion (Misc queries) | |||
Find Nonblank Cell | Excel Worksheet Functions | |||
choose last specific nonblank cell from different worksheets | Excel Discussion (Misc queries) | |||
how to return the value of the last nonblank cell in a row? | Excel Discussion (Misc queries) | |||
Require a cell to be nonblank if another cell is nonblank | Excel Discussion (Misc queries) |