How can I calculate max with condition in Numbers?
In other words, I want something like maxifs, which operates max operation instead of sum operation for sumifs.
How to calculate max with condition in Numbers
numbers
Related Question
- IOS – Calculating a custom total for a column on iPad mini and Numbers
- How to convert a cell with a duration (datetime difference) to number in Numbers
- MacOS – How to make calculations based on smart category summaries in Numbers
- Numbers MAX Formula unexpected result
- Apple Numbers SUMIF with multiple conditions
Best Answer
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.
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.
It's not the same, but it would let you use numbers and not Excel for Mac.