Two columns whit same value
 

Hello ,all
I have question about , macros , can i make macros checking tow column
for same value ,and if value is same move this value ,only same
Example:
1 A1 B1
2 4 10
3 15 4
4 10 15
5 18 13
6 7 11

have to make this

1 A1 B1
2 4 4
3 10 10
4 15 15
5 7 11
6 18 13

Thenks.


--
ceconik
------------------------------------------------------------------------
ceconik's Profile: http://www.excelforum.com/member.php...o&userid=28066
View this thread: http://www.excelforum.com/showthread...hreadid=476151

Two columns whit same value
 

Supplementary question :

What do you expect from the system if there are multiple values that
have the same value ?

Greetings,
Baj

Two columns whit same value
 

Use this formula in an additional column (C)

C1 =IF(A1=B2,B2,B1)

Drag this formula to the end of the table.

The macro is simple now. Just copy column C and paste values only i
cell B1

--
Fa
-----------------------------------------------------------------------
Faz's Profile: http://www.excelforum.com/member.php...fo&userid=2783
View this thread: http://www.excelforum.com/showthread.php?threadid=47615

Two columns whit same value
 

What do you expect from the system if there are multiple values that
have the same value ?

Greetings,

If is have multiple value ,i would like mouve this cell ,example :

1 A1 B1
2 10 10
3 38 38
4 38 38
5 7 6

This , theks again for question


--
ceconik
------------------------------------------------------------------------
ceconik's Profile: http://www.excelforum.com/member.php...o&userid=28066
View this thread: http://www.excelforum.com/showthread...hreadid=476151