Forum Discussion
IF Function
Shouldn't there be a way to look at a column of values and be able to say, if 1 then 30, if 2 then 27, if 3 then 24, if 4 then 21, etc?
=SEQUENCE(30,,30,-3) counts down by 3.
I am assuming the adjacent column is already sorted in rank order...so there's no need then to look at it.
- Perhaps I misinterpreted the OP's requirements.
Big_Event mathetes formula will put values in a range, where as mine is assuming you have that in place and want to enter a number to return said placed values by rank. Rather than continue with two disparate solutions, it would help if you could qualify your needs exactly.Good point, Zack. I took these words from the very first posting--"I'm trying to assign a number value to a previously assigned rank".--to mean that that previous set of data had already been ranked.
But then in my first response, I missed the stepping down by intervals of 3--"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't imagine this being difficult but I just don't know how to write this formula." and SEQUENCE being a relatively new Function, although it's easy, it's not all that well known.
Zack Barresse thanks for staying with me on this one. I will have about 20 recorded times (total seconds required to complete said activity) for an activity. these times will be next to the participant's name. I need to rank these times in order. The fastest time needs to be labeled or noted in a cell as 1, the second fastest as 2, and so on. Then, after the rankings are recorded, I need to assign a numerical "point value" to the rankings. 1st place, or the fastest time, or rank #1, will receive 30 points. The second fastest time will be ranked as #2 and receive 27 points, 3rd will get 21, an so forth. We have three separate activities. I need ranking and points for each of the 3 activities. Then I will calculate the total point for each activity and then sum them to another location for an "overall winner" based on points. Does that make more sense as to my request?
So if your data--person's name and time--are in adjacent cells, all organized as an Excel Table, you can use the relatively new SORT function to sort them into a ranked order, after which that SEQUENCE function could be used.
Do you have a sample of the spreadsheet you're going to be using, dummy names please so as not to violate privacy. If so, please post it.
