How to replicate Excel's "MAXIF" feature in coda

Hi Coda community, I am trying to reference the max of a duplicate reference number. I have assigned ranking values to establish a prioritization among which record to pull, but I am struggling to create a MAXIF/array function to accomplish this task.

In the example below, I am trying to pull priority 4 out of the three rows listed. Please let me know your thoughts and/or if there is a solution to this - thank you!

HI Natalie,

Welcome to the Coda Community!

I have an example and explanation in my Formula Reference Manual here..

Regards
Rambling Pete