Sure. Thanks for the feedback.

Mangesh


"Tushar" wrote in message
...
yeah done...its working fine...

thanks a lot mangesh

tushar

"Mangesh Yadav" wrote:

ok, then enter the following in the 3rd column and drag down:
=IF(COUNTIF($B$1:$B$6,A1)0,A1,"")

and the following in 4th column and drag down
=IF(COUNTIF($B$1:$B$6,A1)0,"",A1 & " does not exist")

Mangesh



"Tushar" wrote in message
...
In case abc exist in both the coloums then it shd print "abc" in the
3rd
coloum
and if pqr not exist then it shd print "pqr not exist" in the 4th
coloum.

All existed cells in both the coloums shd be printed in the 3rd coloum
and
all non existed cells shd be in the 4th coloum

Tushar

"Mangesh Yadav" wrote:

ok fine. And what is the result you expect and where. For instance,
you
compare abc from col1 in col2 and find that abc exists, do you want
to
know
its position, or just some string saying it exists, or just print
abc.

and in case of pqr, what result do you expect and in which cell.

Or do you want the count of the string in question.

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