How to check if cell contains a value of another cell
- by Antonio Oliveira
Here is the scenario:
On column A each cell has random text within it (names, address, account numbers, etc). Column A extends down to over 40 thousand rows.
On column B I have a list of (account) numbers. Column B extends down to about 5 thousand rows.
I need to filter column A to show only the rows that contain the account numbers that are part of column B.
Neither column A nor B are in any specific order.
I think he above scenario speaks for itself, but I can provide a quick example if needed (don't want to over complicate it).