Pull recent 3 most recent entries

[DJFANDANGO]

Hi Guys,

I'm going to change my name to brain fart....

I'm trying to figure out how to pull the top 3 or 3 most recent entries from a data set based on the date...

I'm guessing INDEX/MATCH... but can't figure out the 'date' bit... any help appreciated. Thanks.

Book1
	A	B	C	D	E
1	Data			Last 3 results
2	Date	Audited		Output	Audited
3	23/12/2020			15/10/2020	Yes
4	07/12/2020			27/05/2020	Yes
5	15/10/2020	Yes		14/05/2020	Yes
6	17/09/2020
7	02/08/2020
8	08/07/2020
9	27/05/2020	Yes
10	25/05/2020
11	21/05/2020
12	18/05/2020
13	14/05/2020	Yes
14	15/04/2020
15	23/02/2020
16	10/02/2020
17	01/02/2020
18	07/12/2019
19	26/11/2019
20	24/10/2019	Yes
21	06/10/2019
22	10/09/2019
23	27/08/2019
24	08/08/2019
25	13/07/2019	Yes
26	27/06/2019
27	23/05/2019
28	29/04/2019
29	23/04/2019	Yes
30	04/03/2019
31	24/02/2019
32	22/02/2019
33	16/02/2019
34	17/01/2019
Sheet1

 

[Fluff]

You're welcome & thanks for the feedback.