Hello,
I an excel file, with two Sheets.
So in Sheet1 I have Results in column A and the same thing in Sheet2. Some of them are the same.
I want to compare each of the cells in A column of Sheet1 with all cells in A column of Sheet2 and return "True" to B column of Sheet1. Plus Columns C, D and E should be cleared.
Please see the attached example of how the result should look.
Thank you in advance.
Bookmarks