lets say you want to compare columns A and B.
Enter the followinf formula in column c and copy down.
=IF(A1=B1,A1,"")

Mangesh


"Tushar" wrote in message
...
hi,

i would like to know how can i compare coloums in excel. I have two
coloums
and i want to select common values from these two coloums by comparing
each
cell of 1st coloum with each cell of 2nd coloum. How can i do this?

Tushar