Filter, Sortby...help with formula needed!!

I wish to create a table on Sheet 2 extracted from a table on Sheet 1. I only wish certain columns to be used, driven by whether Col 5 is populated. These will then need to be columnised into a diffe...

Excel

m_tarler
Nov 07, 2024
Yes. you can use a combination of CHOOSECOLS and FILTER and SORT
let assume your original Table is called DataTable, then maybe:
=SORT(FILTER(CHOOSECOLS(DataTable, 5,3,1),CHOOSECOLS(DataTable, 5)<>""))

Patrick2788

Silver Contributor

I may need to see more sample data but you could use GROUPBY to do the filtering and sorting.

=LET(
    cols, CHOOSECOLS(DemoTbl, 5, 3, 1),
    rpt_filter, DemoTbl[Col 5] <> "",
    GROUPBY(cols, , , , 0, , rpt_filter)
)

GROUPBY 11.7.xlsx34 KB

StokieAC

Copper Contributor

Nov 13, 2024

Thanks for your help, but i couldn't get this one to work 😞

Forum Discussion

Filter, Sortby...help with formula needed!!

Share

Resources