120 votes13 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the commentlupo1 commented
I worked around for 2 of them:
The 2nd one is a nice replacement for an arrayable-MIN and -MAX, too (if using a comparison of only 2 arrays). If you want to MIN-MAX n arrays, you stay with the old solution ...SUBTOTAL(...;OFFSET())...