Hello, I have been trying and failing to use values in one column to filter another column. What seems to be making this tricky is that the values in the columns are not equal. For example lets say I want to filter column A to only show cells containing values from the cells in column B, but column A has cells containing 1a, 2a, 3b, 4b. And column B has 1, 3, and 5. So I would like the outcome to spit out a list of the cells in column A that contain values from column B. So given the example above, 1a and 3b would be left after the filter.
I have tried to use advanced filter but it wont work. A snip from my sheet shows 2 columns, you can see the first rows cells are almost the same but there is a prefix, the entire second column has prefix's. I want to take everything from the second column that includes values from the first column.
Bookmarks