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" wrote in message
...
That's nice, thank you for the help.
rod.