Skanda, How often do you have to do this? I write reports and macros for a living.. I have reports with 30,000 lines of data. If I have to do this for an individual report, it's just not worth the effort to write the macro and test it. It's just easier to insert the formula and drag it down.
However, the macros I run that READ 30,000 lines of data and do this thing EVERY DAY, I put it into a macro.. Are the number of rows always the same? is there always data in column A? or B? (to get a count) Paul ________________________________ From: Skanda <skanda.pokkun...@gmail.com> To: excel-macros@googlegroups.com Sent: Tuesday, March 10, 2009 11:57:28 AM Subject: $$Excel-Macros$$ Re: Compare two columns!! Paul, Thanks for the help.Is there any macro for this? On Tue, Mar 10, 2009 at 11:46 AM, Paul Schreiner <schreiner_p...@att.net> wrote: 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
