Microsoft Excel How to: Compare two lists in different worksheets in Excel to locate any duplicates Without VBA… If you can use a helper column, you can use the MATCH function to test if a value in one column exists in another column (or in another …