Sort Unique List of 2 Non-Adjacent Columns by Date Range

[BrettOlbrys1]

Hello. I need a formula that will sort a unique list of two non-adjacent columns based on a date range.

• Company Name is in column A, Date of Sale is in column G, and Total Sale ($) is in column L.
• Company names will repeat often

Based on a specified range of dates to look up, I want to:

• Create a Unique list of company names based on column A
• Sum their Total Sales during that date range
• Order the Unique list of company names based on Total Sales, from greatest to least

 

[Fluff]

How about

+Fluff 1.xlsm
	A						G					L	M	N	O	P	Q
1
2
3	AA						01/03/2022					100			01/02/2022	SH	900
4	AA						01/01/2022					200			06/03/2022	AA	700
5	SH						05/03/2022					300				CAR	500
6	AA						08/02/2022					400
7	CAR						03/03/2022					500
8	SH						07/02/2022					600
9
Lists

Cell Formulas
Range	Formula
P3:Q5	P3	=LET(u,UNIQUE(FILTER(A2:A100,(A2:A100<>"")*(G2:G100>=O3)*(G2:G100<=O4))),SORT(CHOOSE({1,2},u,SUMIFS(L2:L100,A2:A100,u)),2,-1))
Dynamic array formulas.

 

[BrettOlbrys1]

Worked perfectly, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.