Read the last entered value

hhammash

Board Regular
Joined
Jun 24, 2002
Messages
156
Hi,

I have values in column C. The rand is from C2 to C350 I want to put a formula in cell C351 to read only the last entered value in that range.

Example:
When a value like 900 is entered in cell C2 I want C351 to read 900, then when a value like 1200 is entered in cell C3 I want C351 to read 1200 and forget about 900 ...etc.

Thanks a lot
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

hhammash

Board Regular
Joined
Jun 24, 2002
Messages
156
Thank you barry,

It worked perfectly.

Is it possible to explain it for me please?

Thanks a lot again
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
In short, LOOKUP should return the greatest value less than the lookup value from a sorted (ascending) range.

As the lookup value here is the largest number that can be entered in a cell all numbers in your range will be smaller.

Because the range SHOULD be sorted the LAST value in the range is assumed to be the largest and that one is returned (whether the range is indeed sorted or not)
 

hhammash

Board Regular
Joined
Jun 24, 2002
Messages
156
Dear houdini,

Thank a lot for the solution and the explanation.

Thank you
 

Forum statistics

Threads
1,137,366
Messages
5,681,074
Members
419,950
Latest member
BeckiJae

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top