Rank If

Maybe :

Please Login or Register  to view this content.

Hi phimutau,

What number should we look at to do the ranking? Is it the Tot in Column R? We need to know which number is used to even start to work on this problem. Or is it column AP that you are using for the ranking?

Hi phimutau

I can do this problem but as you guessed it isn't an easy one.

If you could get all 120 (3 in your example) teams on a single sheet with Name, Position, ST (points?) you could then do a Pivot Table and Rank them easily. I've done the Pivot Table on Sheet 4). This Pivot Table is the easy part. Getting all players on the same sheet takes a tool build into 2016 called Get & Transform. I used it to do a connection to your 3 sheets. I also cleaned up the data by removing the unneeded top rows and all other rows that didn't have Name, Position and ST. I did this to all 3 sheets, that is the Power Query filter. Then I created an Append Query (using G&T (also known as Power Query)) and appended all 3 sheets into a single table.

Lets call the below a "proof of concept". Your problem can be done using Pivot Tables and Appending all sheets together into a single sheet.

Rank Football Positions Answer.xlsx

Keep this thread alive by asking more or learn from my example.

Marvin, I believe it is :

Originally Posted by phimutau

I would like to have the rank in A49:A119, based off the value in T49:T119 for each position, ie QB, RB, WR, TE and so on.

phimutau, after reading again your requirements :

Originally Posted by phimutau

For the QB position in the file below, QB Donald Miller in the Marist Sheet should rank 1st, QB Earl Simmons in the TX Southern Sheet would be 2nd, and QB Kenneth Williams in the Texas State sheet would be 3rd and so on.

I think you want to join the data on all sheets, then rank based on this joined data. In that case, use this code instead :

Please Login or Register  to view this content.

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.