How to find the Max Valor using INDEX and MATCH?

Rodolfo Garcia

@Jeff Reisman Hello Jeff, Could you please review the case, just to find a solution to this issue. Thanks in advance.

Regards

Rodolfo

Jeff Reisman

@Rodolfo Garcia

I think you'd be better off using a MAX(COLLECT) here.

=MAX(COLLECT({tkpsRangeScore}, {tkpsRange}, Payroll@row))

In English: Collect the values from tkpsRangeScore where the tkpsRange is the same as the Payroll value from this row, and then return the highest number.

Rodolfo Garcia

@Jeff Reisman

Hey Jeff thanks a lot for your help. I appreciate a lot your effort invested in this issue.

Regards

Rodolfo