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
Last edited by selva991; 10-20-2011 at 06:16 AM. Reason: alignment is not proper
I used this formula
Spreadsheet attached=IF(E11&" "&F11&" "&G11=I11&" "&J11&" "&K11,1,0)
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,Originally Posted by selva991
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks