XLOOKUP MAX with several criteria

[virtuosok]

Hi,
I have the following formula which returns the first entry on the list matching several criteria:

=XLOOKUP(1,('CTMS export_All TemPo'!$K$2:$K$100000=$A3)*('CTMS export_All TemPo'!$D$2:$D$100000=$C$1)*('CTMS export_All TemPo'!$V$2:$V$100000="Complete"),'CTMS export_All TemPo'!$W$2:$W$100000)

How do I post process it so that it returns max value instead?
Thank you

 

[Fluff]

How about

=MAX(FILTER('CTMS export_All TemPo'!$W$2:$W$100000,('CTMS export_All TemPo'!$K$2:$K$100000=$A3)*('CTMS export_All TemPo'!$D$2:$D$100000=$C$1)*('CTMS export_All TemPo'!$V$2:$V$100000="Complete")))

 

[virtuosok]

Oh wow this was lightning fast and hugely helpful,
Thank you Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.