Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
retrieve data item in terminal cell
Is there an easy way to retrieve the data item or value in the terminal cell
of a column or row? -- Barth "John" Jones |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
retrieve data item in terminal cell
If the last value in column A is a number than:
=LOOKUP(99^99,A:A) will retreive its value the more complex formula: =IF(ISBLANK($A$65536),LOOKUP(2,1/($A$1:$A$655350),$A$1:$A$65535),$A$65536) will retreive the value regardless of type. -- Gary''s Student - gsnu200856 "bluegospel" wrote: Is there an easy way to retrieve the data item or value in the terminal cell of a column or row? -- Barth "John" Jones |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
retrieve data item in terminal cell
On Sun, 7 Jun 2009 11:19:01 -0700, bluegospel .(nospam)
wrote: Is there an easy way to retrieve the data item or value in the terminal cell of a column or row? For the last entry (most rightward) in a row: =LOOKUP(2,1/(LEN(2:2)0),2:2) For the last entry (most downward) in a column: =LOOKUP(2,1/(LEN(A:A)0),A:A) For versions of Excel prior to Excel 2007, you may not be able to refer to an entire column. So use this instead: =LOOKUP(2,1/(LEN(A1:A65535)0),A1:A65535) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Retrieve Data From Last Cell In Column? | Excel Discussion (Misc queries) | |||
HOW DO I RETRIEVE DATA FROM THE LAST UPDATED CELL IN A ROW | Excel Worksheet Functions | |||
How do I retrieve data into a cell from a web site? | Excel Worksheet Functions | |||
Cell comments and Terminal font: BIG problem | Excel Discussion (Misc queries) | |||
Retrieve last cell with data | Excel Worksheet Functions |