Hi,
Can you someone help me to filter a table with array list? Is that possible? Thanks,
I tried to upload the excel file but my add-in feature is restricted so I can't. Maybe I can provide some images for reference.
I have this data as a table.
then I used =SORT(UNIQUE(TblData2[Year])) to generate an array. The output is
I am trying to filter the data by the array TAKE(G3#,2). Can you please provide me help? Thanks,
Can you someone help me to filter a table with array list? Is that possible? Thanks,
I tried to upload the excel file but my add-in feature is restricted so I can't. Maybe I can provide some images for reference.
I have this data as a table.
then I used =SORT(UNIQUE(TblData2[Year])) to generate an array. The output is
I am trying to filter the data by the array TAKE(G3#,2). Can you please provide me help? Thanks,