Hi there,
My situation is the following: I have a power query with accounts and other columns, but I have to exclude from this table the rows that contains certain accounts. The accounts that I have to exclude are mannualy filled into a table in this same workbook and they are of two kinds, "account xxxxx" or "account starting with xx", so I was wandering if there is a way to filter my final table based on this list of accounts, using the text.startwith function or something similar.
Appreciate any help or insights!
🙂
Hi Carolyne,
Yes, you can join the two tables together based on the accounts present in the list of accounts. There are lots different joins and they are documented here: https://www.myonlinetraininghub.com/excel-compare-two-lists
If you get stuck, please upload a sample Excel file so we can give you a tailored solution.
Mynda
Nice article Mynda. 
Carolyne, as Mynda indicates, you can use a Left Outer Join to accomplish what you need. Review that join type in her article linked above.
