I've been scouring the internet and have found similar queries but nothing accomplishing exactly what I need. Hoping someone can help.
So I have two columns with data as shown below:
Column B Column M
Big Lots Brian
(blank cell) (blank cell)
(blank cell) (blank cell)
Law Office Melanie
Xfinity Brian
What I would like is a list in one column that shows:
Column A
Big Lots
Xfinity
In other words, I want to retrieve all of the values in Column B that have a value of "Brian" in Column M, but ignoring the blank rows.
I know there is a way to do this, but am having trouble figuring it out.
Thanks!
Bookmarks