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!
