Budget Array Formula lookup pulling transactions in wrong order

[ExcelGrinch]

Hi Excel Guru's!

I have one that I'm stuck on and hoping someone might be able to assist with..

Context:
I'm building a budget workbook, comprised of an overview and transaction sheet, the layout for which is below.

The transaction sheet is just a dump of my bank transactions and then I use Type/Subtype to assign relevant budget information.
As an aside, I have a check column which combines a few columns to validate if the transaction is unique. The caveat with this is that the Actual date and Processed date can differ on my transaction statement.

Table 'Transactions'

Date	Check (Used for finding duplicate transactions w/Conditional formatting) -Open to other ideas on identifying duplicates	Description	Type	Sub Type	Amount
23/11/2018	See below table for code	Transfer to Savings	Expenses	Savings	99
23/11/2018	As above	PC Parts	Expenses	Shopping	88
23/11/2018	As above	Food	Expenses	Groceries	66
24/11/2018	As above	Takeout	Expenses	Eating Out	77

<tbody>
</tbody>

Used to check for duplicates

=IF(A1="","",TEXT(A1,"mm")
&
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(UPPER(SUBSTITUTE(C1," ","")),"VISAPURCHASE",""),"PTYL","PTY"),":",""),"YTD","Y"),"VISA","")&F1)

On the overview sheet, I am trying to query the above table to find transactions that are between two dates, match the Type and then use Small() to grab the top (highest expense) 5.

This is the formula I am using to find the cell address of the top transaction that meets that criteria.

Used to find the highest expense within two date ranges, where the type is Expense

{=IFERROR(ADDRESS(SMALL(IF(IF((Transactions[Date]>=$F$22)*(Transactions[Date]<$G$22),Transactions[Type])="Expenses",ROW(Transactions[Amount])), ROW(1:1)),6,1,1,"[New Budget.xlsm]Transactions"),"")}

But, I have found that it is not actually sorting by size. Instead the small appears to be sorting by date, oldest to newest.
Using the below table as an example, row 4 should be row 3 and I think this has something to do with the if ranges I am using.

Date	Description	Type	Amount
23/11/2018	Transfer to Savings	Savings	99
23/11/2018	PC Parts	Shopping	88
23/11/2018	Food	Groceries	66
24/11/2018	Take out	Eating Out	77
etc	etc	etc	etc

<tbody>
</tbody>

I also tried using this formula, but found that it was matching the amount, rather than the row found by the if ranges.

=IFERROR(CELL("address",INDEX(Transactions[Amount],MATCH(SMALL(IF(IF((Transactions[Date]>=$F$22)*(Transactions[Date]<$G$22),Transactions[Type],"")="Expenses",Transactions[Amount],""),1),Transactions[Amount],0))),"")

I think I have all the pieces, but I can't seem to put them together correctly.
I am hoping someone might be able to assist with getting me over this hurdle and if a better idea to filter out duplicate transactions comes up, I would be very interested and forever grateful.