Results 1 to 4 of 4

Excel 2007 : Comparison of Two Tables

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Smile Comparison of Two Tables

    Friends,

    I want to compare two different sets of Tables containing same items (only numbers) .
    eg
    Row table1 table2 if table1 = table 2 then
    1 A1 B1 C1 A2 B2 C2
    2 12 13 1 56 12 5 1
    3 56 12 5 12 13 5 0
    4 23 23 6 12 24 5 0
    12 13 1 1
    23 23 6 1

    here in table 1 and table2 "12 13 1 " , 56 12 5" ,"23 23 6" matches and i want value 1 or 0 to appear. Can we program for this comparison. i have attached my excel sheet also Pls guys i need ur help.

    It would be a great help for me in my work
    Attached Files Attached Files
    Last edited by selva991; 10-20-2011 at 06:16 AM. Reason: alignment is not proper

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