Top 10 Value in a date range with multiple criteria

[conorrey]

Hi,

I have been trying to work out a formula to find a specific value in a large range of data.

I need to find our top 10 RES between a date range between another date range and return the RES number.

I will then use index match to get the whole row of date to create a top 10 list.

Below is the sample data with criteria.

I have tried using Max, Large and Aggregate formulas but I cannot add the date range. It just looks at the whole range

Any help would be great.

Arrival	Res #	TOTAL	Status	Created
01/09/2023	223567	10000.00	Waitlist	02/01/2023
30/09/2023	223597	124.67	Departed	03/01/2023
03/01/2023	223598	232.60	Departed	03/04/2023
13/05/2023	223625	702.95	Departed	03/08/2023
05/01/2023	223660	423.35	Departed	03/11/2023
05/01/2023	223663	343.61	Departed	03/10/2023
29/03/2023	223712	1938.33	Cancelled	20/11/2023
29/03/2023	223713	5242.29	Cancelled	20/10/2023
15/09/2023	223770	435.78	Waitlist	21/01/2023
18/01/2023	223771	1304.37	Waitlist	21/01/2023
10/01/2023	223789	68.28	Departed	20/10/2023
08/03/2023	223796	1794.36	Departed	07/12/2023
11/01/2023	223797	0.00	Departed	06/11/2023
06/01/2023	223799	225.11	Departed	10/07/2023
18/09/2023	223802	1473.12	Cancelled	20/01/2023
		Created	01/01/2023​	30/04/2023​
		Arrival	01/09/2023​	30/09/2023​
		Status	Waitlist
		Total	Max		Top 10
		Result	Column D

 

[Fluff]

To sort on column L change the 3,-1 to 12,-1

 

[conorrey]

To sort on column L change the 3,-1 to 12,-1

Thank you. that worked perfectly

 

[Fluff]

You're welcome & thanks for the feedback.