# how to I pull the last value in a column ?

#### akardar1

##### New Member
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 !

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### Eric W

##### MrExcel MVP
Assuming your values are numeric, try:

Book1
AB
1LastValues
226
33
47
52
6
Sheet1
Cell Formulas
RangeFormula
A2A2=LOOKUP(9E+307,B:B)

BEAUTIFUL !
THANK YOU!

Replies
17
Views
380
Replies
1
Views
87
Replies
2
Views
52
Replies
4
Views
180
Replies
0
Views
215

1,127,994
Messages
5,628,034
Members
416,287
Latest member
wanji

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back