MAX(COLLECT using INDEX(MATCH

Sam Lugiano

Hi,

For the attached sheet excerpt I would like to get the latest Date of Visit that has a checkmark for a Re-Exam and matched to the Barcode @row. I have tried multiple MAX(COLLECT AND INDEX(MATCH variations with no success. Any help will be much appreciated.

Thanks,

Sam

Kelly Moore

Hey @SLUGGO

Try this

=INDEX(MAX(COLLECT([DATE OF VISIT]:[DATE OF VISIT], [DATE OF VISIT]:[DATE OF VISIT], ISDATE(@cell), BARCODE:BARCODE, BARCODE@row, [RE-EXAM]:[RE-EXAM], 1)), 1)

Sam Lugiano

Works great! Thank you.

Kelly Moore

Hey @SLUGGO

Try this

=INDEX(MAX(COLLECT([DATE OF VISIT]:[DATE OF VISIT], [DATE OF VISIT]:[DATE OF VISIT], ISDATE(@cell), BARCODE:BARCODE, BARCODE@row, [RE-EXAM]:[RE-EXAM], 1)), 1)

Sam Lugiano

Works great! Thank you.