Results 1 to 4 of 4

Comparing Multiple sets of Data

Threaded View

michaelweaver4 Comparing Multiple sets of... 02-03-2011, 06:45 PM
MarvinP Re: Comparing Multiple sets... 02-03-2011, 07:00 PM
michaelweaver4 Re: Comparing Multiple sets... 02-03-2011, 08:49 PM
MarvinP Re: Comparing Multiple sets... 02-03-2011, 08:57 PM
  1. #1
    Registered User
    Join Date
    12-29-2010
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    43

    Comparing Multiple sets of Data

    I'm looking for a recommendation on how to approach this. I've attached an example. I have three sets of data that I am comparing. I need to call out differences from one to the other.

    How would I best do this? I think the first step is to identify instances where the data is the same for all three data sets. But here's the thing - the data won't always reside on the same row.

    So from a formula standpoint. Could I do something that would say - for example if you've opened the example attachment - if "ID" exists in C:C, and I:I, and O:O, and if the corresponding information in the next columns, so D:D, J:J, P:P matches - mark it as such. If the information matches in only two of the three (D,J,or P), mark as such.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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