Put this formula in C1
=IF(COUNTIF(B:B,A1)0,A1,B1)
and copy down
Then select column C, copy, EditPastespecial and select Values, and exit.
Then delete column B.
--
HTH
Bob Phillips
"ceconik" wrote in
message ...
Hi all
I wold like to ask about microsoft exel macros , how i can make maiby
macros for this :
i have two columns whit same value example
1 A1 B1
2 12 48
3 74 12
4 14 74
5 48 14
6 5 65
how a can move value in same cell ,make this
1 A1 B1
2 12 12
3 74 74
4 14 14
5 48 48
6 5 65
Thenks
--
ceconik
------------------------------------------------------------------------
ceconik's Profile:
http://www.excelforum.com/member.php...o&userid=28066
View this thread: http://www.excelforum.com/showthread...hreadid=475801