+ Reply to Thread
Results 1 to 3 of 3

Comparing Multiple Columns Ideas

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Microsoft 2013
    Posts
    36

    Comparing Multiple Columns Ideas

    Hi,
    I am looking for ideas on how to quickly compare columns. Just need a simple yes or no if they match. Below is an example of the compares I need to do on the attached spreadsheet. I have several spreadsheets with different sets of schedules to compare. Any thoughts greatly appreciated.
    Thanks

    Schedule 15, 16, 17, 18 matches 167 ?
    Schedule 19 matches 205 ?
    Schedule 20 matches 164 ?
    Schedule 21 matches 158 ?
    Schedule 22 matches 162 ?
    Schedule 23, 24, 25, 26, 27, 28 matches 156 ?
    Schedule 36, 37 matches 160 ?
    Schedule 29, 31, 32, 33, 34 matches 184 ?
    Schedule 30 matches 187 ?
    Schedule 35 matches 190 ?
    Schedule 38, 39, 40, 41, 42, 43, 44, 45 matches 155 ?
    Last edited by dodgemain; 10-25-2018 at 06:43 AM.

  2. #2
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    Re: Comparing Multiple Columns Ideas

    255 COLUMNS WITH two columns at a time means 32385 combinations to be compared. number of rows for each column are variable. how to compare and when to define that a match has occurred?
    ravi shankar

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Comparing Multiple Columns Ideas

    Not sure how accurate this would be, but if you summed each column, then applied Conditional Formatting to that "total" row to check for duplicates, it would maybe give you a start?.

    As mentioned, comparing 255 columns against each other is going to me a major undertaking.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Comparing Multiple Columns In 1 Sheet to Columns in Another
    By anonymous12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2018, 11:40 AM
  2. Comparing multiple columns
    By jjackson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2013, 03:38 PM
  3. [SOLVED] Most efficient way of comparing multiple cells in multiple columns.
    By soxcrates in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2013, 04:12 PM
  4. Comparing a row to multiple columns
    By jdanehl in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-16-2013, 04:18 PM
  5. Replies: 2
    Last Post: 03-15-2013, 05:25 PM
  6. comparing multiple columns
    By webspider in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-19-2012, 01:40 PM
  7. Comparing multiple columns
    By daarun in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-23-2005, 09:20 AM

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