With your example, place the following formulae in subsequent columns and
drag down till the end of column A. Your data lies in columns A and B, and I
am checking the existence of values in A in column B

=COUNTIF($B$1:$B$6,A1)
returns the number of

=MATCH(A1,$B$1:$B$6,0)
returns the position of the val;ue in column A in column B. And if not
present, it returns #N/A

Mangesh



"Tushar" wrote in message
...
but the coloums are not same they are something like below

abc abc
xyz tuv
lmn xyz
pqr
bcd
lmn

so each cell of coloum 1 shd look into the all second coloum cells
for eg coloum 1, cell 1( abc ) shd get compared with each cell of second
coloum then xyz shd get compared with all 2nd coloum cells so on

how can i do this ?

tushar


"Tushar" wrote:

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