How to calculate max with condition in Numbers?
Numbers version 3 on Mac and the equivalent web app/ios app do not have that level of abstraction, but on a Mac, Numbers is fairly scriptable in powerful ways.

I would probably dump the data into a SQLite database if your comment means you are familiar with that. This is documented at the wonderful OS X Automation site.


https://iworkautomation.com/numbers/sqlite-make.html


You could also program the logic you wanted in Applescript or possible the new javascript bridge for AppleScript on later OS X versions. Here is an example of complicated logic used to format cells. You could likely adapt that to process the data and then write the results to a new table.


https://iworkautomation.com/numbers/examples-highlight-intersection.html


It's not the same, but it would let you use numbers and not Excel for Mac.