Hello friends, and thanks in advance for your help (I still contend that I would pay a low monthly subscription fee to be a member in this community. I've gained so much and offered little in return.)
I am trying to create a formula for D2 that will provide the output you see below.
I am trying to isolate the names of the players who represent the top 4 scores on their team, leaving blanks for anyone else.
I have used both large and aggregate functions, but can't get either of them to respect the limits of only selecting from the top 4 within the team (column B)
I've been entering my CSE arrays properly, in case that might be your first thought.
Cheers!
Excel 2016 (Windows) 32 bit
I am trying to create a formula for D2 that will provide the output you see below.
I am trying to isolate the names of the players who represent the top 4 scores on their team, leaving blanks for anyone else.
I have used both large and aggregate functions, but can't get either of them to respect the limits of only selecting from the top 4 within the team (column B)
I've been entering my CSE arrays properly, in case that might be your first thought.
Cheers!
Excel 2016 (Windows) 32 bit
| Player | Team | Pts | Top 4 |
| Babe | Legends | 16 | Babe |
| Ty | Legends | 12 | Ty |
| Ted | Legends | 11 | |
| Jackie | Legends | 8 | |
| Hank | Legends | 7 | |
| Micky | Legends | 9 | |
| Joe | Legends | 13 | Joe |
| Roger | Legends | 17 | Roger |
| Willie | Legends | 5 | |
| Anthony | Whippersnappers | 6 | |
| Mike | Whippersnappers | 7 | |
| Aaron | Whippersnappers | 9 | |
| Paul | Whippersnappers | 12 | Paul |
| Bryce | Whippersnappers | 21 | Bryce |
| Nolan | Whippersnappers | 11 | Nolan |
| Mookie | Whippersnappers | 9 | |
| Giancarlo | Whippersnappers | 8 | |
| Kris | Whippersnappers | 14 | Kris |
| Sheet: Sheet1 |
Last edited:
