Does anyone have a MAXIFS equivalent? MAXIFS is not support by the Jet Web Portal. TIA
Date
Votes
1 comment
-
Harry Lewis Hello Todd -
The user-created, single-cell alternatives to the MAXIFS function (available only with an Office 365 subscription) require either VBA or an array function - neither are supported by the Jet Web Portal.
You could, however, create a report to give you the same information. Here is a rudimentary example based on the data you provided (I moved a couple of your numbers to emphasize how the report works):
When the report is run, the final results are your maximum values:
Please sign in to leave a comment.