Forum Discussion

Renae225's avatar
Renae225
Copper Contributor
Jan 06, 2022

=filter formula

Hi everyone, I am having issues with my =filter formula. It works fine on my computer, but when colleagues open the worksheet and start working on it, the filter doesn’t flow through on different s...
excel
Renae225's avatar
Renae225
Copper Contributor
Jan 06, 2022
Also, is there another formula that would do the same thing, and work in older versions of excel?
  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jan 06, 2022

    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.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources