I'm tracking performance for some athletes and we need a way to see their "Best" workout numbers meaning the highest numbers of (rep × weight).
The table looks like this:
The reps and the weight are different columns and the Dates are 2x merged.
In the above table, the result should read: