Forum Discussion

RogerL75's avatar
RogerL75
Copper Contributor
May 20, 2022
Solved

Excel Filter function

Hi there, I'd like to use the filter function in a special way.   The default result is that the filter function returns the entire row in the same order.   Is there a possibility to use the fi...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    May 20, 2022

    RogerL75 

     

    I suspect this is due to different Regional Settings... Download the attached file, Excel will figure out what the right/correct delimiter is for the columns in INDEX

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
May 20, 2022

RogerL75 

Since you are using 365, you will soon have a further option available to you, namely CHOOSECOLS.

= CHOOSECOLS(
     FILTER(Table1, Table1[head2]="e"),
  5,3,4)

= FILTER(
     CHOOSECOLS(Table1,5,3,4),
  Table1[head2]="e")

with the row and column operations in either order.

  • RogerL75's avatar
    RogerL75
    Copper Contributor
    May 23, 2022
    Many thanks, I've saved this formula, now it's time to wait till MS will release the new functions.

Resources