Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to sort through data
Hi all, I was wandering if anyone can offer any advice on a problem. Basically, in A:A I have a list of numbers. In B:B I have a list of corresponding values. The values in B:B are always unique, but values in A:A may be the same. Identical values will always appear together (eg A1, A2, A3, etc). I want to make a macro to sort through this data, and if A1=A2, copy B2 to C1. If A1=A3, copy B3 to A1. Then move down the list in A:A until it finds the next value....and repeat. So in essence...where values in A:A are identical, column B:B is copied and then transposed into the first cell containing the value. If this does not make sense...the diagram below may help explain! Original list - A B 1 569 1 572 2 433 3 625 4 744 5 766 5 767 5 792 Sorted List - A B C D 1 569 572 1 572 2 433 3 625 4 744 5 766 767 792 5 767 5 792 Thank you in advance for any advice! Robert -- systemx ------------------------------------------------------------------------ systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254 View this thread: http://www.excelforum.com/showthread...hreadid=532528 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Data Macro | Excel Discussion (Misc queries) | |||
Varying Data Sort Macro. | Excel Programming | |||
Using a MACRO to sort data | Excel Worksheet Functions | |||
Using a macro to sort your data in alphabetical order? | Excel Discussion (Misc queries) | |||
data sort macro | Excel Programming |