Aug 09 2021 10:16 PM
Hello all
sometimes in maxifs & minifs we need to use an expression instead of range, but this doesnt work, can you please vote for this feature
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/43969428...
Aug 10 2021 02:54 PM
@chahine
These days in many cases FILTER() is used instead of SOMEIFS() functions, like
=MAX(FILTER(Revenue-Expenses,Year=2020))
