Returning Last Value Only in a column

  • Thread starter Thread starter slarson
  • Start date Start date
Slarson, try something like this, it will return the last numeric valve in
sheet2 column B
=INDEX(Sheet2!B:B,MATCH(9.99999999999999E+307,Sheet2!B:B))
or this for text
=INDEX(Sheet2!B:B,MATCH(REPT("Z",10),Sheet2!B:B,1),1)

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
suppose your data is in columns E, F, G and H starting on
row 10.
in the column that you want the last value on the list
input the formula:
=INDIRECT("E"&COUNTIF(E10:E175,">0")+9)
use a similar formula for F, G and H but substitute the
array range.
This formula allows for data range in a column from row
10 to row 175 but your actual range can be as small or as
large as you want to accommodate your data.
 
Back
Top