This question is a variation of the one discussed in this thread. Say I have the data below in a worksheet. I would like to put a list on another worksheet that shows the undrafted (Drafted? = "No") wide receivers (Position = "WR") sorted in Ranking order. That way, my list of available wide receivers gets smaller as they are drafted by teams.
I can figure out how to adjust the function we built in the linked thread, but that would give me a list by name, and I want the list of names by ranking. (Column AR). Suggestions on how I could do this?
<tbody>
</tbody>
I can figure out how to adjust the function we built in the linked thread, but that would give me a list by name, and I want the list of names by ranking. (Column AR). Suggestions on how I could do this?
| B | C | I | U | AR |
| Position | Name | Drafted? | Ranking | List |
| K | Akers | No | 143 | Johnson,C |
| WR | Alexander | No | 201 | Avery |
| RB | Allen,A | No | 432 | Armstrong |
| TE | Allen,D | No | 341 | Austin,M |
| WR | Allen,K | No | 355 | Alexander |
| WR | Amendola | Yes | 43 | Allen,K |
| DEF | Arizona | No | 102 | |
| QB | Arizona | No | 143 | |
| WR | Armstrong | No | 176 | |
| RB | Asiata | No | 334 | |
| DEF | Atlanta | No | 98 | |
| QB | Atlanta | No | 126 | |
| WR | Austin,M | No | 198 | |
| WR | Austin,T | Yes | 97 | |
| WR | Avery | No | 105 | |
| RB | Ball | Yes | 46 | |
| WR | Johnson,C | No | 1 |
<tbody>
</tbody>
