Two columns of data - How to get the unmatching cell data to colum

[Cpviv]

Hi,

I have column A with 95 cells data and column B with 183 cells data.
Column A has some cells data that not match with column B cells data.
How to get the unmatching data to column C?
At the same time, how to compare duplicates within two columns in a
spreadsheet?

 

[Gaurav]

There might be a better way but try this

in column C enter the following

=IF(COUNTIF($B$1:$B$183,A1)=0,A1,"") and drag all the way down.

To handle duplicates - http://www.cpearson.com/excel/Duplicates.aspx

Hope that helps.