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.
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.
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.netwrote:
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
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
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