Big_EventCopper ContributorApr 30, 2020IF Function I'm trying to assign a number value to a previously assigned rank. For instance, ranking #1 receives a value of 30, ranking #2 receives a value of 27, ranking #3 receives a value of 24, etc. I can'...Show More
Big_EventCopper ContributorApr 30, 2020mathetes I have attached a copy of the spreadsheet I have so far. Test Scoring Spreadsheet.xlsx12 KB
Zack BarresseIron Contributor to Big_EventApr 30, 2020Big_Event perhaps then just, in cell G8: =SEQUENCE(COUNT(F8:F30),,30,-3)
