JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
I have a table that I determine the rank # with this formula:=SUMPRODUCT((ABS(AF7-0)>ABS(AF$5:AF$19-0))+0)+1
To get this:
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:512;width:11pt" width="14"> </colgroup><tbody>
</tbody>
What I looking to do is on another spreadsheet in the workbook put these in order by rank.
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:512;width:11pt" width="14"> </colgroup><tbody>
</tbody>
Is there a formula that will take the 1st table and put it into rank order like the 2nd table on another spreadsheet?
Thank for you help
James
To get this:
Rank # | ||
3 | JKL | 7 |
12 | GGHHI | 5 |
6 | XYZ | 6 |
6 | AABCC | 6 |
6 | DDEEFF | 6 |
3 | GHI | 7 |
3 | MNO | 7 |
1 | ABC | 8 |
1 | DEF | 8 |
6 | STU | 6 |
6 | VW | 6 |
6 | PQR | 6 |
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:512;width:11pt" width="14"> </colgroup><tbody>
</tbody>
What I looking to do is on another spreadsheet in the workbook put these in order by rank.
Rank # | ||
1 | ABC | 8 |
1 | DEF | 8 |
3 | JKL | 7 |
3 | GHI | 7 |
3 | MNO | 7 |
6 | XYZ | 6 |
6 | AABCC | 6 |
6 | DDEEFF | 6 |
6 | STU | 6 |
6 | VW | 6 |
6 | PQR | 6 |
12 | GGHHI | 5 |
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:512;width:11pt" width="14"> </colgroup><tbody>
</tbody>
Is there a formula that will take the 1st table and put it into rank order like the 2nd table on another spreadsheet?
Thank for you help
James