I am looking for a formula in column C to compare a list of names in column A and B, if there are duplicates only show 1 name and any unique/single names also display. Column A is being pulled in from worksheetA and Column B is being pulled in from worksheetB and column C is in worksheetC. I am thinking this is not possible??
Column A Column B Column C
Red Red Red
Blue Red Blue
Red Blue Yellow
Blue Yellow Green
Green Blue
Bookmarks