B bluegospel Jun 7, 2009 #1 Is there an easy way to retrieve the data item or value in the terminal cell of a column or row?
G Gary''s Student Jun 7, 2009 #2 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$65535>0),$A$1:$A$65535),$A$65536) will retreive the value regardless of type.
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$65535>0),$A$1:$A$65535),$A$65536) will retreive the value regardless of type.
R Ron Rosenfeld Jun 7, 2009 #3 Is there an easy way to retrieve the data item or value in the terminal cell of a column or row? Click to expand... 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
Is there an easy way to retrieve the data item or value in the terminal cell of a column or row? Click to expand... 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
