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" <Tushar@discussions.microsoft.com> wrote in message
news:5FEB09DE-8B0F-490A-9272-78E9ACEAB5DA@microsoft.com...
> 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