Excel Comparison

  Leepaci 16:50 02 Sep 09
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 09

How many columns are there?

  Simsy 07:01 03 Sep 09

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

Regards,

Simsy

  Leepaci 10:35 03 Sep 09

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…