comparing 2 sheets
 

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

comparing 2 sheets
 

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

comparing 2 sheets
 

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

comparing 2 sheets
 

welcome, rod.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rodchar" wrote in message
...
That's nice, thank you for the help.
rod.