Data Comparison Tool

[JosephineM]

Hello,

I conduct a weekly audit report for 5000 employees. The report is always in the same format such as employee number, department, status, location etc (~10 fields).

I have an excel spreadsheet that I currently use with multiple index, nested IF and And Statements and vlookup formulas but I'm hoping for an cleaner/easier solution.

Is there an ad on tool to compare data?

Thank you!
Jo

 

[Smitty]

Welcome to the Board!

What are you trying to compare?

Take a look at Spreadsheet Compare which is an add-in for Excel 2013.

 

[JosephineM]

Welcome to the Board!

What are you trying to compare?

Take a look at Spreadsheet Compare which is an add-in for Excel 2013.

Hi Smitty - sorry, I forgot to mention I'm on Excel 2010.
I can't upgrade to Excel 2013 because the Oracle system I use is only compatible with 2007 and 2010.

 

[Smitty]

There might be other options, but you'll need to explain what you're actually trying to compare.

 

[JosephineM]

There might be other options, but you'll need to explain what you're actually trying to compare.

I conduct a weekly audit report for 5000 employees.
The report is always in the same format. The fields consists of employee number (8 unique digits), department, status, location, grade, manager (8 unique digits).
I want to run a comparison for week 1 vs. week 2 and highlight cells in week 2 spreadsheet of data that is different in week 1.

 

[Smitty]

I'd probably use VLOOKUP based on Employee # and the field you want to compare. You can use Conditional Formatting to highlight cells that aren't equal.