Most valuable professional
  • Hot Topics

Excel Comparing and finding differences in rows with multiple columns between two worksheets

I'm not sure if this has been answered before but I've been looking for an answer to this and couldn't find one. Maybe someone can help me This is Sheet1 containing client details ID 1111 2222 3333 4444 This is Sheet2 that I get from colleagues that may have added or removed clients, containing their updated details and not in the same position (I made the changes in Bold) ID 2222 1111 4444 5555

This question generated 28 answers. To proceed to the answers, click here.

This thread is current as of February 23, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel