Comparing Workbooks

  • I have a list of ~4000 numbers in one workbook and a list of another 300 numbers in another workbook, same spreadsheet. I have been trying to figure out how to see if the list of 300 is in the list of 4000 and to display a check mark to signify that this number is duplicated. Any help would be greatly appreciated!

  • Hi.


    You can use the COUNTIF function to check how many times a certain value appears in a range. You can then use "Conditional Formatting" to display the duplicates. See the example workbook.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!