Hi,
I'm having trouble solving rating problems with other models such as sorting the rankings from the smallest value of the combined two scores (two sessions)... for more details, see the attachment, thank you for all the help,
Regads.
Hi,
I'm having trouble solving rating problems with other models such as sorting the rankings from the smallest value of the combined two scores (two sessions)... for more details, see the attachment, thank you for all the help,
Regads.
Last edited by herukuncahyono; 06-24-2022 at 06:46 AM.
It may be just me, but i am confused what you are basing your ranking results in column I by. I tried summing scores 1 and 2 but the rankings don't make sense with how you want them. Can you try elaborating a little more.
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Hi dosydos,
The question is the formula in column F... And in column I that is the result it should be (I filled it manually, not from the formula,but by sorting combination scores 1 and 2 and skipping preexisting names or no duplication )
BTW, I have included the manual calculation below
#actually the score of the data value in seconds (duration) so whoever is the fastest (the smallest value) is the highest rating
Regrads
Last edited by herukuncahyono; 06-23-2022 at 08:02 PM.
Try in F5
Please Login or Register to view this content.
Hi soledad,
Thank you for helping to solve my problem
regards
Cell F5 formula , Drag down
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks