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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5