Hi,

I have a table with P&L data and i need to filter out certain account names. See Raw Data tab. I have a table of all the account names that should be filtered out (tab Filter List). I loaded the filter list to a query and converted it to a list. I ensured that the type of the list records is Text. Then i created a Query called PL that pulls the table from the Raw Data tab and that is supposed to filter out any records matching the Filter list (GLTotals query). I am not getting an error message, but the list is not being filtered at all (see tab PL). I am not sure why this does not work. The Data Types match, i used the Trim function in Excel to ensure that there are no extra spaces and it still does not work. ChatGPT could not figure it out either 🙂 Any help is appreciated. File is attached.

Thanks,

Dana