Hello!
I have two lists in one spreadsheet of Excel. The lists are in Columns A and B. Column A has 23 values, while Column B has over 37,000. All of the values in Column A appear somewhere in Column B, but obviously not vice versa. I am trying to align the values in Column A with the their exact matches in Column B, while leaving the cells in between blank.
I've experimented with a few formulas, but have had no luck.
Does anyone know how to do this?
Thank-you.
Erik
Bookmarks