+ Reply to Thread
Results 1 to 1 of 1

Comparing two separate similar sets of data to find differences

  1. #1
    Registered User
    Join Date
    11-06-2008
    Location
    Illinois
    Posts
    63

    Question Comparing two separate similar sets of data to find differences

    Hello all,

    Within the attached you will find two tabs: Master and Compare. The data within the Master tab is generated from a central database and the data in the Compare tab is my own personal file.

    I am trying to compare the highlighted data within the Master tab with the highlighted date within the Compare tab to point out any differences between them and then show a side-by-side comparison in a new sheet with Master and Compare column headers. The data labeled N/A is not important for comparing purposes but will always remain in those specified columns.

    Neither the Master nor Compare tabs contain the "correct" data. Some data for a certain entry will (and should) be different as the data is always changing. My goal here is to simply display which data differs from sheet to sheet. Any suggestions or ideas would be greatly appreciated!

    Thanks,

    Nick
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1