Google sheet help
Google sheet help
I've been editing a Google Sheet form and aiming to set up descending ranks based on specific criteria. Each participant must meet certain goals—like achieving 95% or more—to receive the highest points, with a cap of 12 points for each player. Those below that threshold will automatically move down in ranking. Help appreciated.
I might not grasp exactly what you're aiming for, but I think it relates to using an IF statement in Excel when assigning scores. For instance, if a player is 95% or higher, give them the maximum score; otherwise, calculate it. Then decide the best way to sort the results.
I don’t rely on Google Sheets and am not comfortable with formula formatting, though I’m very comfortable with Excel.
I attempted to capture a few screenshots of your Google Sheet, hiding any personal details. I reviewed the columns and rows before and after the ranking rules were applied. I investigated how the spreadsheet handles ties and examined the functions used, trying to understand the logic behind the ranking. I also considered examples where individual objectives or percentages might be listed on index cards for manual sorting. You can share the images here via imgur (www.imgur.com).
I used the same method before, as the highest percentage gives the most points in descending order. However, when only a few meet the criteria for the top rank, I need to add a condition.
Now I'm adding an extra column with the formula that checks if A1 is greater than 97%; if yes, it gives 100%, otherwise it gives 0%.
This applies to the 8 people from the 12 who achieved 97%, which currently get 4 points. I need to add 12 points to them.
So anyone reaching a percentage of 97,00 or higher should receive 12 points — correct?
It might be better to develop a function to decide when a 12-point award is appropriate.
For reference:
https://www.ablebits.com/office-addins-b...ons-excel/
https://bettersolutions.com/excel/functi...ctions.htm
These are just suggested starting points.
You can also locate more relevant links that match your needs and abilities.