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
mathetesGold ContributorApr 30, 2020Big_Event Assuming you want these in columns, the SEQUENCE function can do it: =SEQUENCE(30,,30,-1)If you want them in a row, =SEQUENCE(,30,30,-1) You might need to have an Office 365 subscription; I'm not sure whether this function is generally available outside of that.
