Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy multiple collumns with multiple conditions.
I have a spreadsheet in which I need to copy data from four collumn into 58 collumns with all the numbers in each collumn that correspond with the new letter. Example: ABC BCD CDA DAB A: 1 2 3 4 B: 5 6 7 8 C: 9 10 11 12 D: 13 14 15 16 E: 17 18 19 20 Result A B C D Collumns repeat A: 1 2 3 4 B: 5 6 7 8 C: 9 10 11 12 D: 13 14 15 16 E: 17 18 19 20 F: 3 1 1 2 G: 7 5 5 6 H: 11 9 9 10 I: 15 13 13 14 J: 19 17 17 18 K: 4 4 2 3 L: 8 8 6 7 M: 12 12 10 11 N: 16 16 14 15 O: 20 20 18 19 I was able to manage this using array functions but th information in the first page changes fairly often and I need th result sheet to remain static. After the first four collumns the dat will be arranged differently.(I already have code to sort it after i has been placed). If anyone could point me in the right direction to do this I woul appreciate it -- goobe ----------------------------------------------------------------------- goober's Profile: http://www.excelforum.com/member.php...fo&userid=1983 View this thread: http://www.excelforum.com/showthread.php?threadid=47843 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count for multiple conditions in multiple columns | Excel Worksheet Functions | |||
Setting multiple conditions to return a figure from multiple cells | Excel Discussion (Misc queries) | |||
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) | |||
How do I add multiple values that match multiple conditions? | Excel Discussion (Misc queries) | |||
Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions |