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

RogerL75's avatar
RogerL75
Copper Contributor
May 20, 2022

Himtarler ,

similar to the result that I get with the formula that L.Z. has posted, I get the following result with your formula.

Do you know what I did wrong?

Roger

mtarler's avatar
mtarler
Silver Contributor
May 20, 2022

use comma instead of semi-colon in the list (I believe this is the main issue in both cases above)
=INDEX( .....; {1,8,3})
and since you will need to use the SEQUENCE(ROWS(Datatable)) to call all the rows for those defined columns I will edit my previous answer to suggest:

= FILTER( INDEX(Datatable, SEQUENCE(ROWS(Datatable)), {5,3,4}) , Datatable[head2]="e","")

 

Resources