hey all,
i have 2 worksheets. i want to compare 1 column (Column C) and see if the
numbers are equal and put yes or no in an empty column next to it. is this
possible?

thanks,
rodchar

Assume identical length data running in C1 down in both Sheet1 and Sheet2.

In Sheet2,

In D1:
=IF(C1="","",IF(C1=Sheet1!C1,"Yes","No"))
Copy down to last row of data in col C.

This compares* it cell-for-cell between Sheet2 and Sheet1,
ie Sheet2's C1 with Sheet1's C1, Sheet2's C2 with Sheet1's C2, ...
*except case sensitivity


In E1:
=IF(C1="","",IF(ISNUMBER(MATCH(C1,Sheet1!C:C,0)),"Yes","No"))
Copy down to last row of data in col C

This compares* it cell-with-col between Sheet2 and Sheet1, ie
Sheet2's C1 found within Sheet1's C:C ?,
Sheet2's C2 found within Sheet1's C:C ?, and so on
*except case sensitivity
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rodchar" wrote:
> hey all,
> i have 2 worksheets. i want to compare 1 column (Column C) and see if the
> numbers are equal and put yes or no in an empty column next to it. is this
> possible?
>
> thanks,
> rodchar

That's nice, thank you for the help.
rod.

"rodchar" wrote:

> hey all,
> i have 2 worksheets. i want to compare 1 column (Column C) and see if the
> numbers are equal and put yes or no in an empty column next to it. is this
> possible?
>
> thanks,
> rodchar

welcome, rod.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rodchar" <(E-Mail Removed)> wrote in message
news:2AA8E5DA-2391-4B41-90F4-(E-Mail Removed)...
> That's nice, thank you for the help.
> rod.