you can also try
a1=b1
true and false condition.
--- On Thu, 3/12/09, vijender kumar wrote:
From: vijender kumar
Subject: $$Excel-Macros$$ Re: Compare two columns!!
To: excel-macros@googlegroups.com
Date: Thursday, March 12, 2009, 2:38 AM
Hi
On reply of your first query please use
Hi
On reply of your first query please use the below formula for column C for
finding if A and B column are equal or not.
=IF(A1=B1,"0","1")
On reply of your second query you simply use the Minus function.
=A1-B1
If you have any query then pls let me know
Regards
On 3/10/09, Skanda wrote:
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 d
groups.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 wrote:
This is basic Excel functionality.
let's say your sample data is in row
Paul,
Thanks for the help.Is there any macro for this?
On Tue, Mar 10, 2009 at 11:46 AM, Paul Schreiner 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
Hi Skanda,
Not just 1000 but even if you've 5 or more rows of data, you can
drag your formula down to fill all cells of rows automatically. Here
is how to achieve it:
1. Suppose you've data in rows 1 to 1000. and data in Col A and Col B.
Then, Type Formula as suggested in Col C and Col D.
2
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
Ashish,
Thanks for the help. This is helpful if we have less number of rows. If I
have a couple of thousand how do we do it?I mean a macro or something like
that.
On Tue, Mar 10, 2009 at 11:38 AM, Ashish Jain <26may.1...@gmail.com> wrote:
>
>
> -
Hi Skanda,
Try this formula based solution:
Col A Col B Col C Col
D
Row 1 5 5 =IF(A1=B1,0,1)
