most recent value

Green1972

Board Regular
Joined
Dec 8, 2008
Messages
161
Hi Al.
l Ihave a problem that i hope you can help me with.
What i have in column A is a series of dates from cell A5 - A50.
In column C i have a set of ramdem numbers
When the date in any cell in column A is reached a stock check is done and the result is entered in the corrisponding cell in column C .
What i want to do in Cell D1 in have the date the last stock check was completed and in Cell D2 in the result of that stock check (the figure from the corrisponding cell in column C). Hope you can help :laugh::confused:
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Hi,

I don't think this is the best solution, but it appears to work!!!


Excel Workbook
ABCDEF
1Date*Result17/05/2011*23/05/2011
201/01/2011*1020**
309/01/2011*2020**
417/01/2011*1020**
525/01/2011*20***
602/02/2011*10***
710/02/2011*20***
818/02/2011*10***
926/02/2011*20***
1006/03/2011*10***
1114/03/2011*20***
1222/03/2011*10***
1330/03/2011*20***
1407/04/2011*10***
1515/04/2011*20***
1623/04/2011*10***
1701/05/2011*20***
1809/05/2011*10***
1917/05/2011*20***
2025/05/2011*****
Sheet1


I have given you 3 ways to find the value in column C, take your pick.
I hope that works for you.

Ak
 
Upvote 0
Hi,

Some other ways......


Excel Workbook
ABCDEF
1Date*Result17/05/2011*23/05/2011
201/01/2011*118**
309/01/2011*218*17/05/2011
417/01/2011*318*17/05/2011
525/01/2011*418*17/05/2011
602/02/2011*5***
710/02/2011*6***
818/02/2011*7***
926/02/2011*8***
1006/03/2011*9***
1114/03/2011*10***
1222/03/2011*11***
1330/03/2011*12***
1407/04/2011*13***
1515/04/2011*14***
1623/04/2011*15***
1701/05/2011*16***
1809/05/2011*17***
1917/05/2011*18***
2025/05/2011*****
Sheet1


I hope one of these is suitable.

Ak
 
Upvote 0
Hi Al.
l Ihave a problem that i hope you can help me with.
What i have in column A is a series of dates from cell A5 - A50.
In column C i have a set of ramdem numbers
When the date in any cell in column A is reached a stock check is done and the result is entered in the corrisponding cell in column C .
What i want to do in Cell D1 in have the date the last stock check was completed and in Cell D2 in the result of that stock check (the figure from the corrisponding cell in column C). Hope you can help :laugh::confused:
Try this...

Book1
ABCDE
21/27/200088_5/27/200593
36/4/200031___
43/22/200154___
54/9/200175___
610/28/200199___
79/14/200277___
85/11/200384___
912/16/200423___
105/27/200593___
117/31/2005____
1211/6/2006____
139/20/2007____
1410/18/2009____
1510/23/2009____
168/14/2010____
176/9/2011____
185/26/2013____
195/25/2014____
206/13/2014____
Sheet1

Formula entered in D2:

=LOOKUP(1E100,B2:B20,A2:A20)

Formula entered in E2:

=LOOKUP(1E100,B2:B20)
 
Upvote 0
Brilliant. I traied all of them and they worked great. They gave me what i wanted, when and where i wanted them. Thank you
;)
 
Upvote 0

Forum statistics

Threads
1,224,541
Messages
6,179,418
Members
452,912
Latest member
alicemil

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
Back
Top