Sort and order a dynamic list based upon other criteria?

wbtczn

New Member
Joined
Aug 31, 2011
Messages
26
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?
BCIUAR
PositionNameDrafted?RankingList
KAkersNo143Johnson,C
WRAlexanderNo201Avery
RBAllen,ANo432Armstrong
TEAllen,DNo341Austin,M
WRAllen,KNo355Alexander
WRAmendolaYes43Allen,K
DEFArizonaNo102
QBArizonaNo143
WRArmstrongNo176
RBAsiataNo334
DEFAtlantaNo98
QBAtlantaNo126
WRAustin,MNo198
WRAustin,TYes97
WRAveryNo105
RBBallYes46
WRJohnson,CNo1

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

wbtczn

New Member
Joined
Aug 31, 2011
Messages
26
Resurrecting this thread....I didn't ever receive any input on my question, but I still have the question. Please help??
 

Watch MrExcel Video

Forum statistics

Threads
1,108,674
Messages
5,524,211
Members
409,565
Latest member
Suilenroc

This Week's Hot Topics

Top