Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Modification
Folks:
(IF(ISERROR(MATCH(B1,A:A,0)),"No Match","Match") Column A Column B Column C 25 50 No Match 30 30 Match 26 28 No Match 55 60 I am using the above formula to compare two columns (A and B) for overlapping (common) data then put the result ("Match" OR "No Match") in a third column. So far this formula has worked well. But now I would like to modify this formula so that rather than "Match" or "No Match" the overlapping result ("30" in this case), gets put into Column C. Thanks, Jo. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Modification
Do you still want "no match" ?
=IF(ISNA(MATCH(B1,A:A,0)),"No Match",B1) Or, this will leave "no match" cells blank: =IF(ISNA(MATCH(B1,A:A,0)),"",B1) Biff <JoJo wrote in message ... Folks: (IF(ISERROR(MATCH(B1,A:A,0)),"No Match","Match") Column A Column B Column C 25 50 No Match 30 30 Match 26 28 No Match 55 60 I am using the above formula to compare two columns (A and B) for overlapping (common) data then put the result ("Match" OR "No Match") in a third column. So far this formula has worked well. But now I would like to modify this formula so that rather than "Match" or "No Match" the overlapping result ("30" in this case), gets put into Column C. Thanks, Jo. |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
Formula Modification
try this
=IF(A1-B1=0,A1,"") "JoJo" wrote: Folks: (IF(ISERROR(MATCH(B1,A:A,0)),"No Match","Match") Column A Column B Column C 25 50 No Match 30 30 Match 26 28 No Match 55 60 I am using the above formula to compare two columns (A and B) for overlapping (common) data then put the result ("Match" OR "No Match") in a third column. So far this formula has worked well. But now I would like to modify this formula so that rather than "Match" or "No Match" the overlapping result ("30" in this case), gets put into Column C. Thanks, Jo. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
last modification | Excel Discussion (Misc queries) | |||
MODIFICATION IS NOT ALLOWED | Excel Worksheet Functions | |||
text modification | Excel Worksheet Functions | |||
Macro Modification Help | Excel Worksheet Functions | |||
Formula Modification Help | Excel Worksheet Functions |