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