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?
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]B[/TD]
[TD]C[/TD]
[TD]I[/TD]
[TD]U[/TD]
[TD]AR[/TD]
[/TR]
[TR]
[TD]Position[/TD]
[TD]Name[/TD]
[TD]Drafted?[/TD]
[TD]Ranking[/TD]
[TD]List[/TD]
[/TR]
[TR]
[TD]K[/TD]
[TD]Akers[/TD]
[TD]No[/TD]
[TD]143[/TD]
[TD]Johnson,C[/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Alexander[/TD]
[TD]No[/TD]
[TD]201[/TD]
[TD]Avery[/TD]
[/TR]
[TR]
[TD]RB[/TD]
[TD]Allen,A[/TD]
[TD]No[/TD]
[TD]432[/TD]
[TD]Armstrong[/TD]
[/TR]
[TR]
[TD]TE[/TD]
[TD]Allen,D[/TD]
[TD]No[/TD]
[TD]341[/TD]
[TD]Austin,M[/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Allen,K[/TD]
[TD]No[/TD]
[TD]355[/TD]
[TD]Alexander[/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Amendola[/TD]
[TD]Yes[/TD]
[TD]43[/TD]
[TD]Allen,K[/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]Arizona[/TD]
[TD]No[/TD]
[TD]102[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QB[/TD]
[TD]Arizona[/TD]
[TD]No[/TD]
[TD]143[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Armstrong[/TD]
[TD]No[/TD]
[TD]176[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RB[/TD]
[TD]Asiata[/TD]
[TD]No[/TD]
[TD]334[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]Atlanta[/TD]
[TD]No[/TD]
[TD]98[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QB[/TD]
[TD]Atlanta[/TD]
[TD]No[/TD]
[TD]126[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Austin,M[/TD]
[TD]No[/TD]
[TD]198[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Austin,T[/TD]
[TD]Yes[/TD]
[TD]97[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Avery[/TD]
[TD]No[/TD]
[TD]105[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RB[/TD]
[TD]Ball[/TD]
[TD]Yes[/TD]
[TD]46[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Johnson,C[/TD]
[TD]No[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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?
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]B[/TD]
[TD]C[/TD]
[TD]I[/TD]
[TD]U[/TD]
[TD]AR[/TD]
[/TR]
[TR]
[TD]Position[/TD]
[TD]Name[/TD]
[TD]Drafted?[/TD]
[TD]Ranking[/TD]
[TD]List[/TD]
[/TR]
[TR]
[TD]K[/TD]
[TD]Akers[/TD]
[TD]No[/TD]
[TD]143[/TD]
[TD]Johnson,C[/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Alexander[/TD]
[TD]No[/TD]
[TD]201[/TD]
[TD]Avery[/TD]
[/TR]
[TR]
[TD]RB[/TD]
[TD]Allen,A[/TD]
[TD]No[/TD]
[TD]432[/TD]
[TD]Armstrong[/TD]
[/TR]
[TR]
[TD]TE[/TD]
[TD]Allen,D[/TD]
[TD]No[/TD]
[TD]341[/TD]
[TD]Austin,M[/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Allen,K[/TD]
[TD]No[/TD]
[TD]355[/TD]
[TD]Alexander[/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Amendola[/TD]
[TD]Yes[/TD]
[TD]43[/TD]
[TD]Allen,K[/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]Arizona[/TD]
[TD]No[/TD]
[TD]102[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QB[/TD]
[TD]Arizona[/TD]
[TD]No[/TD]
[TD]143[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Armstrong[/TD]
[TD]No[/TD]
[TD]176[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RB[/TD]
[TD]Asiata[/TD]
[TD]No[/TD]
[TD]334[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]Atlanta[/TD]
[TD]No[/TD]
[TD]98[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]QB[/TD]
[TD]Atlanta[/TD]
[TD]No[/TD]
[TD]126[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Austin,M[/TD]
[TD]No[/TD]
[TD]198[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Austin,T[/TD]
[TD]Yes[/TD]
[TD]97[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Avery[/TD]
[TD]No[/TD]
[TD]105[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RB[/TD]
[TD]Ball[/TD]
[TD]Yes[/TD]
[TD]46[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WR[/TD]
[TD]Johnson,C[/TD]
[TD]No[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]