Excel Comparison

  Leepaci 16:50 02 Sep 2009
Locked

Hi, I'm trying to compare two excel spreadsheets which contain over 2,000 rows of data.

The two sheets should contain almost the same info with perhaps 50 or so discrepencies.

I am thinking there must be some way of checking for discrepencies other than me having to manually search through 2000 or so rows of data.

Can anyone help me please?

  VoG II 17:22 02 Sep 2009

How many columns are there?

  Simsy 07:01 03 Sep 2009

do you want to do when you've found the discrepancies/differences?

Regards,

Simsy

  Leepaci 10:35 03 Sep 2009

Thanks for your responses but I have solved the problem using a great little tool called ASAP Utilities which has allowed me to highlight two columns and highlight all of those that are duplicated thus leaving those discrepancies highlighted (or not as the case may be).

Thanks again.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?