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