Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloums comparison in excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloums comparison in excel
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloums comparison in excel
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloums comparison in excel
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloums comparison in excel
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloums comparison in excel
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloums comparison in excel
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloums comparison in excel
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
coloums comparison in excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Choose amount appears at first coloums | Excel Worksheet Functions | |||
How do I add every other coloums in a linked sheet? | Excel Discussion (Misc queries) | |||
how do I limit the number of coloums? | Excel Discussion (Misc queries) | |||
How to match the Coloums | Excel Discussion (Misc queries) | |||
Help with macro to make it loop through coloums | Excel Programming |