• Displaying rows which match a criterion

    From Philip Herlihy@21:1/5 to All on Sat Jan 7 12:02:47 2023
    I can't any longer access or see the thread which asked how to get Excel to display a list of rows from a range which exceed a value elsewhere in the workbook. I'd suggested looking at Pivot Tables or Power Query.

    I've just spotted that a function in very recent versions of Excel (later than mine) can do just this. If you're still out there, have a look at the
    FILTER() function.


    --

    Phil, London

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)