Forum Discussion
Solved
Filter a table with an array list
Hi, Can you someone help me to filter a table with array list? Is that possible? Thanks,
What do you mean by "Filter a table with array"? Here few approach from assumption.
=FILTER(TblData2,COUNTIFS(G2:G3,TblData2[Year]))=GROUPBY(TblData2[Year],TblData2[Amount],SUM,0,0)
What do you mean by "Filter a table with array"? Here few approach from assumption.
=FILTER(TblData2,COUNTIFS(G2:G3,TblData2[Year]))=GROUPBY(TblData2[Year],TblData2[Amount],SUM,0,0)