Extract Acrobatics

[RicardoCubed]

Extract Acrobatics = Looking for a modification to extractformula that will order records in date ascending order AND then by dollaramount lowest to highest. So, recordswould in this case be in the following order by Person.
Person3
Person8
Person5
Person2
Person4

Can this be done formulaically? Help appreciated. Thanks in advance.

Book1
	A	B	C
1	extract acrobatics
2	Database
3	DOH	Name	Salary
4	01/01/18	Person1	50,000
5	03/01/18	Person2	45,000
6	02/01/18	Person3	65,000
7	04/01/18	Person4	35,000
8	02/15/18	Person5	70,000
9	06/01/18	Person6	30,000
10	07/01/18	Person7	80,000
11	02/15/18	Person8	60,000
12	09/01/18	Person9	90,000
13	06/15/18	Person10	72,500
14	11/01/18	Person11	83,900
15	12/01/18	Person12	48,500
16
17	Lower	2/1/2018
18	Upper	4/1/2018
19	Count	5
20
21	Extract
22	DOH	Name	Salary
23	03/01/18	Person2	45,000
24	02/01/18	Person3	65,000
25	04/01/18	Person4	35,000
26	02/15/18	Person5	70,000
27	02/15/18	Person8	60,000
28	-	-	-
Sheet1

Cell Formulas
Range	Formula
B19	=COUNTIFS($A$4:$A$15,">="&$B$17,$A$4:$A$15,"<="&B18)
B23	=IFERROR(INDEX(B$4:B$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(D$23:D23))),"-")
B24	=IFERROR(INDEX(B$4:B$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(D$23:D24))),"-")
B25	=IFERROR(INDEX(B$4:B$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(D$23:D25))),"-")
B26	=IFERROR(INDEX(B$4:B$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(D$23:D26))),"-")
B27	=IFERROR(INDEX(B$4:B$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(D$23:D27))),"-")
B28	=IFERROR(INDEX(B$4:B$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(D$23:D28))),"-")
A23	=IFERROR(INDEX(A$4:A$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(C$23:C23))),"-")
A24	=IFERROR(INDEX(A$4:A$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(C$23:C24))),"-")
A25	=IFERROR(INDEX(A$4:A$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(C$23:C25))),"-")
A26	=IFERROR(INDEX(A$4:A$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(C$23:C26))),"-")
A27	=IFERROR(INDEX(A$4:A$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(C$23:C27))),"-")
A28	=IFERROR(INDEX(A$4:A$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(C$23:C28))),"-")
C23	=IFERROR(INDEX(C$4:C$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(E$23:E23))),"-")
C24	=IFERROR(INDEX(C$4:C$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(E$23:E24))),"-")
C25	=IFERROR(INDEX(C$4:C$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(E$23:E25))),"-")
C26	=IFERROR(INDEX(C$4:C$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(E$23:E26))),"-")
C27	=IFERROR(INDEX(C$4:C$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(E$23:E27))),"-")
C28	=IFERROR(INDEX(C$4:C$15,AGGREGATE(15,6,(ROW($A$4:$A$15)-ROW($A$4)+1)/(($A$4:$A$15<=$B$18)*($A$4:$A$15>=$B$17)),ROWS(E$23:E28))),"-")

 

[oldbrewer]

[TABLE="width: 245"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]DOH[/TD]
[TD]Name[/TD]
[TD]Salary[/TD]
[/TR]
[TR]
[TD="align: right"]15/06/2018[/TD]
[TD]Person10[/TD]
[TD="align: right"]72,500[/TD]
[/TR]
[TR]
[TD="align: right"]15/02/2018[/TD]
[TD]Person8[/TD]
[TD="align: right"]60,000[/TD]
[/TR]
[TR]
[TD="align: right"]15/02/2018[/TD]
[TD]Person5[/TD]
[TD="align: right"]70,000[/TD]
[/TR]
[TR]
[TD="align: right"]12/01/2018[/TD]
[TD]Person12[/TD]
[TD="align: right"]48,500[/TD]
[/TR]
[TR]
[TD="align: right"]11/01/2018[/TD]
[TD]Person11[/TD]
[TD="align: right"]83,900[/TD]
[/TR]
[TR]
[TD="align: right"]09/01/2018[/TD]
[TD]Person9[/TD]
[TD="align: right"]90,000[/TD]
[/TR]
[TR]
[TD="align: right"]07/01/2018[/TD]
[TD]Person7[/TD]
[TD="align: right"]80,000[/TD]
[/TR]
[TR]
[TD="align: right"]06/01/2018[/TD]
[TD]Person6[/TD]
[TD="align: right"]30,000[/TD]
[/TR]
[TR]
[TD="align: right"]04/01/2018[/TD]
[TD]Person4[/TD]
[TD="align: right"]35,000[/TD]
[/TR]
[TR]
[TD="align: right"]03/01/2018[/TD]
[TD]Person2[/TD]
[TD="align: right"]45,000[/TD]
[/TR]
[TR]
[TD="align: right"]02/01/2018[/TD]
[TD]Person3[/TD]
[TD="align: right"]65,000[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/2018[/TD]
[TD]Person1[/TD]
[TD="align: right"]50,000

this would be order for date descending and salary ascending[/TD]
[/TR]
</tbody>[/TABLE]

 

[RicardoCubed]

Oldbrewer. Thanks for looking at - but not what I was asking/looking for.
Was wondering if the formula (s) that extract the data based on the date range criteria could be modified so that in the dataset it pulls first based on date ASCENDING and then orders by dollar amount.
Perhaps not a clear posting. Regards

 

[oldbrewer]

[TABLE="width: 245"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]DOH[/TD]
[TD]Name[/TD]
[TD]Salary[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/2018[/TD]
[TD]Person1[/TD]
[TD="align: right"]50,000[/TD]
[/TR]
[TR]
[TD="align: right"]02/01/2018[/TD]
[TD]Person3[/TD]
[TD="align: right"]65,000[/TD]
[/TR]
[TR]
[TD="align: right"]03/01/2018[/TD]
[TD]Person2[/TD]
[TD="align: right"]45,000[/TD]
[/TR]
[TR]
[TD="align: right"]04/01/2018[/TD]
[TD]Person4[/TD]
[TD="align: right"]35,000[/TD]
[/TR]
[TR]
[TD="align: right"]06/01/2018[/TD]
[TD]Person6[/TD]
[TD="align: right"]30,000[/TD]
[/TR]
[TR]
[TD="align: right"]07/01/2018[/TD]
[TD]Person7[/TD]
[TD="align: right"]80,000[/TD]
[/TR]
[TR]
[TD="align: right"]09/01/2018[/TD]
[TD]Person9[/TD]
[TD="align: right"]90,000[/TD]
[/TR]
[TR]
[TD="align: right"]11/01/2018[/TD]
[TD]Person11[/TD]
[TD="align: right"]83,900[/TD]
[/TR]
[TR]
[TD="align: right"]12/01/2018[/TD]
[TD]Person12[/TD]
[TD="align: right"]48,500[/TD]
[/TR]
[TR]
[TD="align: right"]15/02/2018[/TD]
[TD]Person8[/TD]
[TD="align: right"]60,000[/TD]
[/TR]
[TR]
[TD="align: right"]15/02/2018[/TD]
[TD]Person5[/TD]
[TD="align: right"]70,000[/TD]
[/TR]
[TR]
[TD="align: right"]15/06/2018[/TD]
[TD]Person10[/TD]
[TD="align: right"]72,500[/TD]
[/TR]
</tbody>[/TABLE]