See attached. I have attached a macro that might help you. _________________________________________________________________________________________________ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: Skanda <skanda.pokkun...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Tuesday, 10 March, 2009 8:02:47 PM
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
Add more friends to your messenger and enjoy! Go to
http://messenger.yahoo.com/invite/
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
Book1.xls
Description: MS-Excel spreadsheet
