Happy New year !!!
Hi My friends, this time i need a formula that may most of you know.
Yes, i know the conventional Index/match/ formula with Indirect from/to another sheet. but this time is lil bit different. this is what i need to achieve:
On a Single sheet
On A1:J1 <-- numbered from 1 to 10
On A50:J50 <-- each Cell contain 3 digits: e.i 000,010,222..
On A51:J51 <-- each cell contain scores
Note: Via Macro is added 2 rows So Row A20:J20 and A21:J21 Scroll down 1 row, and the new data is entered on Empty row 20 and 21 (via macro as well)
Because A20:J21 move 1 row, i need to use INDIRECT (to keep at least 10 values on archive )
This is the Actual data :
<tbody>
</tbody>
Then I need to Index Match The Numbers (A1:J1) that match the 3 Digits (A20:J20) and Indexed from most to least by the Score (A21:J21)
I need to Start coping the numbers and formulas on
AA2:AJ2 (numbers)
AA3:AJ3 (3 digits)
AA4:AJ4 (Score <- everything indexed by Most to least Score)
Example : of the desired output
<tbody>
</tbody>
Thanks !!!
Hi My friends, this time i need a formula that may most of you know.
Yes, i know the conventional Index/match/ formula with Indirect from/to another sheet. but this time is lil bit different. this is what i need to achieve:
On a Single sheet
On A1:J1 <-- numbered from 1 to 10
On A50:J50 <-- each Cell contain 3 digits: e.i 000,010,222..
On A51:J51 <-- each cell contain scores
Note: Via Macro is added 2 rows So Row A20:J20 and A21:J21 Scroll down 1 row, and the new data is entered on Empty row 20 and 21 (via macro as well)
Because A20:J21 move 1 row, i need to use INDIRECT (to keep at least 10 values on archive )
This is the Actual data :
A1:J1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
A20:J20 | 000 | 001 | 021 | 200 | 100 | 000 | 020 | 211 | 001 | 001 |
A21:J21 | 2 | 3 | 1 | 1 | 1 | 2 | 1 | 1 | 3 | 3 |
<tbody>
</tbody>
Then I need to Index Match The Numbers (A1:J1) that match the 3 Digits (A20:J20) and Indexed from most to least by the Score (A21:J21)
I need to Start coping the numbers and formulas on
AA2:AJ2 (numbers)
AA3:AJ3 (3 digits)
AA4:AJ4 (Score <- everything indexed by Most to least Score)
Example : of the desired output
AA2:AJ2 | 2 | 9 | 10 | 1 | 6 | 7 | 3 | 5 | 4 | 8 |
AA3:AJ3 | 001 | 001 | 001 | 000 | 000 | 020 | 021 | 100 | 200 | 211 |
AA4:AJ4 | 3 | 3 | 3 | 2 | 2 | 2 | 1 | 1 | 1 | 1 |
<tbody>
</tbody>
Thanks !!!