April 19, 2018
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!
July 16, 2010
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.myonlinetraininghu.....-two-lists
If you get stuck, please upload a sample Excel file so we can give you a tailored solution.