formula to find most recent date

[buteaur]

Can you build a formula to only pull data associated with the most recent date?

Example:

A1 - A100 has dates ranging from 06/25/18 - 08/11/17

I only want the data from the most recent date. This report will be updated everyday so I was hoping to have a formula that I can use everyday.

Thank you

 

[jproffer]

Maybe something like this:

Excel 2013/2016
	A	B	C
1	6/25/2018	A	A
2	6/24/2018	B
3	6/23/2018	C
4	6/22/2018	D
5	6/21/2018	E
6	6/20/2018	F
7	6/19/2018	G
8	6/18/2018	H
9	6/17/2018	I
10	6/16/2018	J
11	6/15/2018	K
12	6/14/2018	L
13	6/13/2018	M
14	6/12/2018	N
15	6/11/2018	O
16	6/10/2018	P
17	6/9/2018	Q
18	6/8/2018	R
19	6/7/2018	S
20	6/6/2018	T
Sheet1

Cell Formulas
Range	Formula
C1	=VLOOKUP(MAX(A1:A20),A1:B20,2,FALSE)

The dates can be in any order, I just happen to have them in rev order because it was simple and quick.

 

[buteaur]

Hello. Thank you for the quick response. When I put this vlookup in, it pulled all data for all dates not just the newest date.

Any thoughts?

Thanks again!

 

[buteaur]

Think I figured it out. I just locked it to start at $a$1.

Thank you!

 

[Aladin Akyurek]

If dates are in chronological order...

=LOOKUP(9.99999999999999E+307,Dates,Values)