Using CHOOSECOLS + FILTER to return only specific columns

Hi all,Sharing a small dynamic-array trick using CHOOSECOLS + FILTER.Say you have a table TableData with columns: ID, Name, Department, Location, Salary.You can filter by Department and Location, and return only Name and Salary like this: =CHOOSECOLS( FILTER( TableData, (TableData[Department]=G1) * (TableData[Location]=G2) ), 2, 5 ) G1 = Department, G2 = Location, and 2, 5 are the column numbers (Name, Salary) in the filtered spill.Anyone else using CHOOSECOLS in interesting ways?Do you want me to also add a tiny data example in the post so it’s clearer for people replying?