Set the top 11 players on a list according to highest percentages (Google Sheets)
The list of players (COLUMN D) is ranked from most important to least important, but I want to list the 11 players who participated most in the last three matches.
If the top 11 had the same percentage, I could use the MAX function as I tried to do. But the percentages are not equal.
What I would need was to create a way to find the highest percentages until he found 11 players.
One problem is that when trying to find lower percentages, it lists more than 11 if they have more players with the same percentage.
For example: If happen to complete the list of 11 players need to define between two that have 50%, the chosen one must be the highest one in COLUMN D
I thought of FILTER + LEN to get to 11, but couldn't find a pattern for finding the lowest percentages and the highest rating in COLUMN D as a tiebreaker.
Below the spreadsheet link for ease of understanding: https://docs.google.com/spreadsheets/d/1Fh2todBAFApGNyKw3f30p3pAAD3DHOVv6qqymHPxLyo/edit?usp=sharing
maybe try this:
=QUERY(D4:H, "select D order by H desc limit 11", 0)
- Synchronously sort multiple separate arrays by sorting one array naturally
- What exactly does the while loop do here in insertion sort?
- How to order a data frame by one descending and one ascending column?
- How to find the median of deepest subarrays of multidimensional array?
- Sort a 2D array by one of its columns
- Sort an array of single-element arrays by float value
- Sort a 2d array by one of the columns
- Sort a 2D array by a column DESC
- Sort a 2d Array by a column
- Sort second level arrays of a three-level array by column
- Sort an array of single-element arrays by value descending and preserve keys
- Sort each subarray of a 2d array by delimited string values
- What's the fastest algorithm for sorting a linked list?
- How do i sort an array of array in PHP?
- Optimal algorithm for returning top k values from an array of length N
- Naturally sort an array of objects by column value
- How to sort an array by its keys
- Sorting a flat array returns 1 instead of the modified array
- Sort rows of a 2d array to always have a specified value as the first element
- PHP Sorting Inner, Inner Array
- Sort an array by its keys ascending
- Move nominated value of a flat array to become the first element
- Sort rows of a 2d array by a column descending
- Sort rows of a 2D array by a column
- Sort single-element rows of a 2d array in a descending direction
- Reorder dictionaries within a list
- How to randomly select by type probability all items from a google sheet column range
- Sort CSV file based on first column
- Sort all rows of a 2d array according to one row and maintain columnar relationships
- Sort rows of a 2d array by a column