This is basic Excel functionality. let's say your sample data is in rows 2,3,4 (column headings in row 1)
to "build" your function, select Cell C2 and start the Function Wizard select the "IF" function. with the type-in bar in the Logical_Test box, click cell A2, then type <> and click in cell B2. the result should read: A2<>B2 In the next box (Value_if_true), enter 0 in the next box (Value_if_false), enter 1. then hit "ok" to complete the formula. the result should be: =IF(A2<>B2,1,0) You COULD use: =IF(A2=B2,0,1) which tests if they are the SAME instead if different. In column D, use the function wizard to make: =IF(C2=0,0,A2-B2) then, copy these formulas down the rows... P ________________________________ From: Skanda <skanda.pokkun...@gmail.com> To: excel-macros@googlegroups.com Sent: Tuesday, March 10, 2009 10:32:47 AM Subject: $$Excel-Macros$$ Compare two columns!! Hi Guys, If I need to compare two columns in the same worksheet say column A and Column B. If there is a difference between two corresponding cells in A and B then result should be '1' in correspoding cell in column C else result should be '0'.And the difference between col A andCol B should be displayed in Col D Also the same scenario if we need to compare two columns in two worksheets how is this achieved? Col A Col B Col C Col D 5 5 0 0 7 2 1 5 4 9 1 -5 Thanks for your help --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
