Results 1 to 13 of 13

comparing the rows in different columns and displaying the results

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2007
    Location
    Turkey-Bartın/
    MS-Off Ver
    Ms Office-2007
    Posts
    44

    comparing the rows in different columns and displaying the results

    Hi
    I have two groups of lottery results. The first group has the last year results of 200 rows, and the second group displays this year results of 100 rows. I want to start comparing the first row of the second group (green group) with all the rows of the first group( blue group) giving me a count of how many matches are found.. And do the same search for all the other rows of green group…
    Please have a look at the attachment file.
    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Comparing two columns and displaying a third value if they match
    By pdxcollegegrl in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-29-2012, 12:46 PM
  2. Comparing 4 columns and displaying duplicate entries
    By Tonx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2012, 03:26 AM
  3. [SOLVED] Comparing 2 columns and Displaying the associated row in another column
    By William123 in forum Excel General
    Replies: 25
    Last Post: 04-12-2012, 08:18 AM
  4. Replies: 1
    Last Post: 10-28-2010, 12:12 PM
  5. comparing 2 columns and count results
    By lbeamer2688 in forum Excel General
    Replies: 2
    Last Post: 10-16-2008, 05:50 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