Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to compare two columns
Hi
I have two columns one has names automated from another worksheet and one has other names entered manually (the two columns show two attendences) example Column A = town Column B = Country jack black Sue Smith snow white Jack Black using A1 as an example I want a formula to check if the name in A1 is in B1:b2000 and if it is type yes and if not no Any help as always appreciated -- Thanks Lise |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to compare two columns
Hi Lise
Try this formula in C1 and copy it down as required: =IF(ISERROR(MATCH(A1,$B$1:$B$1000;0)),"No","Yes") Regards, Per On 31 Jul., 04:55, Lise wrote: Hi I have two columns one has names automated from another worksheet and one has other names entered manually (the two columns show two attendences) example Column A = town *Column B = Country jack black * * * * * * * * * * * * * * * Sue Smith snow white * * * * * * * * * * * * * * Jack Black using A1 as an example I want a formula to check if the name in A1 is in B1:b2000 and if it is type yes and if not no Any help as always appreciated -- Thanks Lise |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to compare two columns
Thanks Per unfortunately this brings back yes to all rather than yes or no??
any other thoughts -- Thanks Lise "Per Jessen" wrote: Hi Lise Try this formula in C1 and copy it down as required: =IF(ISERROR(MATCH(A1,$B$1:$B$1000;0)),"No","Yes") Regards, Per On 31 Jul., 04:55, Lise wrote: Hi I have two columns one has names automated from another worksheet and one has other names entered manually (the two columns show two attendences) example Column A = town Column B = Country jack black Sue Smith snow white Jack Black using A1 as an example I want a formula to check if the name in A1 is in B1:b2000 and if it is type yes and if not no Any help as always appreciated -- Thanks Lise |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to compare two columns
Make sure that calculation is set to automatic
(Tools|options|calculation tab in xl2003 menus) If that doesn't help, share the formula you used--or try Per's suggestion one more time. (and remember to use either commas or semicolons as your operation separator--Per had a typo in his.) Lise wrote: Thanks Per unfortunately this brings back yes to all rather than yes or no?? any other thoughts -- Thanks Lise "Per Jessen" wrote: Hi Lise Try this formula in C1 and copy it down as required: =IF(ISERROR(MATCH(A1,$B$1:$B$1000;0)),"No","Yes") Regards, Per On 31 Jul., 04:55, Lise wrote: Hi I have two columns one has names automated from another worksheet and one has other names entered manually (the two columns show two attendences) example Column A = town Column B = Country jack black Sue Smith snow white Jack Black using A1 as an example I want a formula to check if the name in A1 is in B1:b2000 and if it is type yes and if not no Any help as always appreciated -- Thanks Lise -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to compare two columns
Hi Dave
I like your formula , taken from your other post =isnumber(match(A1,B1:B1000,0)) it works well. Any reason not to use it. Regards John "Dave Peterson" wrote in message ... Make sure that calculation is set to automatic (Tools|options|calculation tab in xl2003 menus) If that doesn't help, share the formula you used--or try Per's suggestion one more time. (and remember to use either commas or semicolons as your operation separator--Per had a typo in his.) Lise wrote: Thanks Per unfortunately this brings back yes to all rather than yes or no?? any other thoughts -- Thanks Lise "Per Jessen" wrote: Hi Lise Try this formula in C1 and copy it down as required: =IF(ISERROR(MATCH(A1,$B$1:$B$1000;0)),"No","Yes") Regards, Per On 31 Jul., 04:55, Lise wrote: Hi I have two columns one has names automated from another worksheet and one has other names entered manually (the two columns show two attendences) example Column A = town Column B = Country jack black Sue Smith snow white Jack Black using A1 as an example I want a formula to check if the name in A1 is in B1:b2000 and if it is type yes and if not no Any help as always appreciated -- Thanks Lise -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to compare two columns
Nope.
If you're ok seeing true/false and not Yes/no, then you're fine. But Per's (corrected) formula should work, too. John wrote: Hi Dave I like your formula , taken from your other post =isnumber(match(A1,B1:B1000,0)) it works well. Any reason not to use it. Regards John "Dave Peterson" wrote in message ... Make sure that calculation is set to automatic (Tools|options|calculation tab in xl2003 menus) If that doesn't help, share the formula you used--or try Per's suggestion one more time. (and remember to use either commas or semicolons as your operation separator--Per had a typo in his.) Lise wrote: Thanks Per unfortunately this brings back yes to all rather than yes or no?? any other thoughts -- Thanks Lise "Per Jessen" wrote: Hi Lise Try this formula in C1 and copy it down as required: =IF(ISERROR(MATCH(A1,$B$1:$B$1000;0)),"No","Yes") Regards, Per On 31 Jul., 04:55, Lise wrote: Hi I have two columns one has names automated from another worksheet and one has other names entered manually (the two columns show two attendences) example Column A = town Column B = Country jack black Sue Smith snow white Jack Black using A1 as an example I want a formula to check if the name in A1 is in B1:b2000 and if it is type yes and if not no Any help as always appreciated -- Thanks Lise -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to compare columns | Excel Discussion (Misc queries) | |||
Formula to compare numbers in 3 columns 3/23/08 | Excel Discussion (Misc queries) | |||
Formula to compare numbers in 3 columns | Excel Discussion (Misc queries) | |||
Excel Formula or tool to compare two columns of data | Excel Worksheet Functions | |||
Formula needed to compare columns | New Users to Excel |