Comparing 2 non-sequence Sheets in excel to find unique results
Hello Everyone,
I hope you all are doing well and staying safe. I have 2 different datasets Sheet 1 and Sheet 2. In both sheets majority data is duplicate but some data in Sheet 1 is unique which I am trying to capture. Is there a way I can do it easily by using any formula to highlight or extract only unique records.
NOTE - In both sheets data is not sequenced which means if value (E78.2) is in H2 row, the same value is in (I2) in sheet 2 which makes difficult to search exact unique/duplicate values in excel for me. I have attached a test file showing Sheet 1, Sheet 2 and a manual unique result sheet as well to better understand what I am looking for.
Your help is much appreciated. Thank you so much for your time and support.
Bookmarks