title: I want to compare two lists in different worksheets in Excel to locate any duplicates
body: <p>I know this is very simple but I still need help:</p>
  
  <p>I have a list of properties that have finished a training. I need the names of the ones that have not done this training, but the system does not give me such a list. However, I have a list of all our properties. That means I have to compare two columns in different worksheets. </p>
  
  <p>The properties are identified by <code>ID</code> Numbers. What would make my life easier is that if there is a <code>formula</code> that can detect <code>duplicates</code> and highlight on the complete list of hotels so the ones that are not highlighted have not done the training. </p>
  
  <p>Let me know if you have any recommendations for me!</p>