Hi,
I'm tryng to Index Match from a Dynamic Range of 6 pairs of columns, The column work as:
Col A= Numbers, Col B=Values
Col C= Numbers, Col D=Values
Col E= Numbers, Col F=Values
Col G= Numbers, Col H=Values
Col I= Numbers, Col J=Values
Col K= Numbers, Col L=Values
Notes:
-.Numbers on each columns are from 1 to 100
-.Values are between 0 to 45
-.Each column are using 100 rows plus 2 rows (heading)
__A___B___C___D___E___F___G___H___I____J___K___L
<tbody>
</tbody>
What I need is to pull the Numbers from Range A3:K6 (Columns A,C,E,G,I,K)
And sum each point belong to each Number,
Number sorted by most values to least (left to right)
Example of desired Otput of numbers sorted by values
<tbody>
</tbody>
Thank you !!!!!
I'm tryng to Index Match from a Dynamic Range of 6 pairs of columns, The column work as:
Col A= Numbers, Col B=Values
Col C= Numbers, Col D=Values
Col E= Numbers, Col F=Values
Col G= Numbers, Col H=Values
Col I= Numbers, Col J=Values
Col K= Numbers, Col L=Values
Notes:
-.Numbers on each columns are from 1 to 100
-.Values are between 0 to 45
-.Each column are using 100 rows plus 2 rows (heading)
__A___B___C___D___E___F___G___H___I____J___K___L
Num | PO | Num | PO | Num | PO | Num | PO | Num | PO | Num | PO |
34 | 34 | 33 | 7 | 33 | 7 | 33 | 7 | 03 | 10 | 34 | 41 |
26 | 24 | 03 | 7 | 03 | 7 | 03 | 7 | 01 | 9 | 03 | 34 |
20 | 20 | 18 | 6 | 18 | 6 | 18 | 6 | 08 | 9 | 30 | 25 |
10 | 19 | 30 | 6 | 30 | 6 | 30 | 6 | 25 | 8 | 28 | 24 |
24 | 18 | 21 | 5 | 21 | 5 | 21 | 5 | 09 | 6 | 24 | 16 |
13 | 16 | 25 | 5 | 25 | 5 | 25 | 5 | 33 | 6 | 11 | 14 |
04 | 16 | 15 | 4 | 15 | 4 | 15 | 4 | 15 | 6 | 07 | 11 |
02 | 14 | 31 | 4 | 31 | 4 | 12 | 4 | 06 | 6 | 20 | 11 |
01 | 10 | 12 | 4 | 12 | 4 | 31 | 4 | 27 | 5 | 17 | 6 |
<tbody>
</tbody>
What I need is to pull the Numbers from Range A3:K6 (Columns A,C,E,G,I,K)
And sum each point belong to each Number,
Number sorted by most values to least (left to right)
Example of desired Otput of numbers sorted by values
Numbers | 34 | 3 | 30 | 26 | 28 | 33 | 20 | 10 | 18 | 1 | 8 | 25 |
Values sumed | 75 | 65 | 43 | 24 | 24 | 21 | 20 | 19 | 18 | 9 | 9 | 8 |
<tbody>
</tbody>
Thank you !!!!!