Hi,
I have the following formula which returns the first entry on the list matching several criteria:
How do I post process it so that it returns max value instead?
Thank you
I have the following formula which returns the first entry on the list matching several criteria:
Excel Formula:
=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)
Thank you