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