Jan 06 2022 03:00 AM
Jan 06 2022 03:38 AM
Note: This function is currently available only to Microsoft 365 subscribers.
Jan 06 2022 03:55 AM
Jan 06 2022 04:01 AM
Jan 06 2022 04:24 AM
@Renae225 In the older Excel versions 2007 or 2012 you can find the function
via Data -> Sort and Filter “-> Filter
In current versions such as Microsoft 365 or Office 2019, however, the filter function can be found in the Start menu in the "Edit" area.
But no matter which Excel you use. In all cases you can use sums, averages or other functions in a filtered list. Excel then generates results that depend on which data records are currently visible in a list.
There are many ways that lead to Rome and there are many more ways that can lead to a suggested solution in Excel.
Maybe with ... Dynamically filter Excel lists by function - AGGREGATE and FIND
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Jan 06 2022 05:36 AM
“can’t change part of an array” means you try to change the cell inside the spill returned by FILTER(). You may change only entire formula in top left cell of the spill.