Excel 2007 : Comparison of Two Tables

**selva991** · 10-20-2011, 06:06 AM

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

**Nikeyg** · 10-20-2011, 07:20 AM

I used this formula

Please Login or Register  to view this content.

Spreadsheet attached

**selva991** · 10-21-2011, 05:08 AM

Thank You Nikeyg, But my data actually contains atleast 1000 rows , how can i manually enter for 1000 rows , is there any other option to check ???

**veejar** · 10-21-2011, 05:19 AM

Originally Posted by selva991

Thank You Nikeyg, But my data actually contains atleast 1000 rows , how can i manually enter for 1000 rows , is there any other option to check ???

Dear Selva,

You can try Conditional Formatting and see then you need not put any other checks and it can for any number of data rows.

Regards,

Veejar