how to I pull the last value in a column ?

[akardar1]

Hi Team,

I have a column B with values:
6
3
7
how to i return the last value "7" in cell A1 ?
the next day, there is an additional value in the column B
6
3
7
2
I now want cell A1 to return "2" ?

Thanks !

 

[Eric W]

Assuming your values are numeric, try:

Book1
	A	B
1	Last	Values
2	2	6
3		3
4		7
5		2
6
Sheet1

Cell Formulas
Range	Formula
A2	A2	=LOOKUP(9E+307,B:B)

 

[akardar1]

BEAUTIFUL !
THANK YOU!