How do I combine the MAX function with the EXACT function?

This is kind of a time sensitive question. Although, if you find this thread days after I post it I would still appreciate your input.

The issue is simple:

I have one tab with Lead IDs and another tab with Call records with a Lead ID column

The problem is that the lead IDs can be almost identical with the exception of a single letter case difference (i.e. - 'A' instead of 'a')

The goal is the find the longest call made to each Lead ID. (The call duration is in the Call tab.)

I need a MAX or MAXIFS that is Case Sensitive.

I know how to write a case sensitive COUNTIF using SUMPRODUCT.
And I know how to write a general lookup using an array formula and a combination of INDEX, MATCH, & EXACT.

But combing MAX or MAXIFS with EXACT has proven quite a hill to climb.

If you know of any way to find the Maximum value in one column based on an exact case sensitive match in a different column I would really appreciate the help.

FYI: the following was my best attempt at solving this...

{=MAX(IF(EXACT(leads!A2,calls!$I$2:$I$37378),calls!$N$2:$N$37378,0))}

it did not work...and I don't know why.

Try with aggregate

leads

B2=AGGREGATE(14,6,Calls!N2:N1000/EXACT(leads!A2,Calls!I2:I1000),1)

LOL....it turns out that the column my calls tab wasn't formatted correctly
it the array max function w/ exact was trying to work with numbers formatted as text
once I corrected my source data the function I wrote, as you stated, worked.
Thanks for giving me hope to check my formula again. Was about to abandon it.

Originally Posted by ChemistB

Your formula seemed to work for me (See attached) although I admittedly did it on a much smaller range. Large ranges and Arrayed formulas might cause a sizable calculation delay.

LOL....it turns out that the column my calls tab wasn't formatted correctly
it the array max function w/ exact was trying to work with numbers formatted as text
once I corrected my source data the function I wrote, as you stated, worked.
Thanks for giving me hope to check my formula again. Was about to abandon it.

I forgot to include your quote...sorry.