|
compare column1 with column2
Hi, How do i compare column1 with column2 and output in column3. ex. column1 column2 output test1 test4 test1 test2 test6 test2 test4 test1 test4 test6 test2 test6 Thanks for you help. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
compare column1 with column2
You have not told use what criterion to use in the output column.
Do you want the largest of the two values? either =MAX(A1:B1) or IF(A1B1,A1,B1) copy down the column best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "myguess21" wrote in message ... Hi, How do i compare column1 with column2 and output in column3. ex. column1 column2 output test1 test4 test1 test2 test6 test2 test4 test1 test4 test6 test2 test6 Thanks for you help. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
compare column1 with column2
Thanks for quick response. No this is string. Just want to search the value from column 2 i column1 if found out put in column 3 -- myguess2 ----------------------------------------------------------------------- myguess21's Profile: http://www.excelforum.com/member.php...fo&userid=2957 View this thread: http://www.excelforum.com/showthread.php?threadid=49278 |
compare column1 with column2
in C1
=if(match(B1,A:A,0),A1,"") then drag fill down the column. -- Regards, Tom Ogilvy "myguess21" wrote in message ... Thanks for quick response. No this is string. Just want to search the value from column 2 in column1 if found out put in column 3. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
compare column1 with column2
Some formulas to try:
=IF(A1=B1,A1,"") =IF(FIND(B1,A1),A1,"") =IF(SEARCH(B1,A1),A1,"") -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "myguess21" wrote in message ... Thanks for quick response. No this is string. Just want to search the value from column 2 in column1 if found out put in column 3. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
compare column1 with column2
Oh dear I mean to use MATCH not FIND!
Time to retire!!! -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Bernard Liengme" wrote in message ... Some formulas to try: =IF(A1=B1,A1,"") =IF(FIND(B1,A1),A1,"") =IF(SEARCH(B1,A1),A1,"") -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "myguess21" wrote in message ... Thanks for quick response. No this is string. Just want to search the value from column 2 in column1 if found out put in column 3. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
compare column1 with column2
Is this is what you meant? (Search col A for each element in col B?)
=IF(MATCH(B1,A:A,0),B1,"") red blue blue green white white blue yellow #N/A black black black white blue blue but in both cases how do you get rid of "#N/A" when there is no match? "Tom Ogilvy" wrote: in C1 =if(match(B1,A:A,0),A1,"") then drag fill down the column. -- Regards, Tom Ogilvy "myguess21" wrote in message ... Thanks for quick response. No this is string. Just want to search the value from column 2 in column1 if found out put in column 3. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
compare column1 with column2
Should actually be:
=if(isnumber(match(B1,A:A,0)),A1,"") -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... in C1 =if(match(B1,A:A,0),A1,"") then drag fill down the column. -- Regards, Tom Ogilvy "myguess21" wrote in message ... Thanks for quick response. No this is string. Just want to search the value from column 2 in column1 if found out put in column 3. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
compare column1 with column2
Not if you look at the OP's example. It is as I wrote it and I posted a
correction to account for the N/A. -- Regards, Tom Ogilvy "Charlie" wrote in message ... Is this is what you meant? (Search col A for each element in col B?) = IF(MATCH(B1,A:A,0),B1,"") red blue blue green white white blue yellow #N/A black black black white blue blue but in both cases how do you get rid of "#N/A" when there is no match? "Tom Ogilvy" wrote: in C1 =if(match(B1,A:A,0),A1,"") then drag fill down the column. -- Regards, Tom Ogilvy "myguess21" wrote in message ... Thanks for quick response. No this is string. Just want to search the value from column 2 in column1 if found out put in column 3. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
compare column1 with column2
The original example seems a little unusual. Maybe it's a VLookup problem:
=VLOOKUP(B1,A:B,2,FALSE) test1 test4 test3 test2 test6 test5 test4 test3 test1 test6 test5 #N/A test3 test1 test4 "Tom Ogilvy" wrote: in C1 =if(match(B1,A:A,0),A1,"") then drag fill down the column. -- Regards, Tom Ogilvy "myguess21" wrote in message ... Thanks for quick response. No this is string. Just want to search the value from column 2 in column1 if found out put in column 3. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
compare column1 with column2
P.S. thanks for the #N/A correction
"Tom Ogilvy" wrote: Not if you look at the OP's example. It is as I wrote it and I posted a correction to account for the N/A. -- Regards, Tom Ogilvy "Charlie" wrote in message ... Is this is what you meant? (Search col A for each element in col B?) = IF(MATCH(B1,A:A,0),B1,"") red blue blue green white white blue yellow #N/A black black black white blue blue but in both cases how do you get rid of "#N/A" when there is no match? "Tom Ogilvy" wrote: in C1 =if(match(B1,A:A,0),A1,"") then drag fill down the column. -- Regards, Tom Ogilvy "myguess21" wrote in message ... Thanks for quick response. No this is string. Just want to search the value from column 2 in column1 if found out put in column 3. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
compare column1 with column2
Yes. this is what i need to do. Thanks a lot. Charlie Wrote: Is this is what you meant? (Search col A for each element in col B?) =IF(MATCH(B1,A:A,0),B1,"") red blue blue green white white blue yellow #N/A black black black white blue blue but in both cases how do you get rid of "#N/A" when there is no match? "Tom Ogilvy" wrote: in C1 =if(match(B1,A:A,0),A1,"") then drag fill down the column. -- Regards, Tom Ogilvy "myguess21" wrote in message ... Thanks for quick response. No this is string. Just want to search the value from column 2 in column1 if found out put in column 3. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
| All times are GMT +1. The time now is 10:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com