Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock cell whit first value | Excel Worksheet Functions | |||
excel remake whit shadow all the row where i am edit | Excel Worksheet Functions | |||
Sum of cells whit the same name | Excel Worksheet Functions | |||
How can I get the record from excel whit asp? | Excel Programming | |||
help whit hyperlink | Excel Programming |