[Dropped] Give #1,2,3,4,5 values 5,4,3,2,1 (sport analysis)

[captain73]

First post:

I have to say, I'm not a techy by any stretch, and I've done my head in watching videos on YouTube

Q: I'm arranging a point system based on results (I'm using this in sports analysis), in particular;

1st place = 6 point
2nd = 5
3rd = 4
4th = 3
5th = 2
6th = 1


How do I go about this?

[Villeroy]

If this is about ranking:
=RANK(A1 ; $A$1:$A$6 ; 0)
with points in A1:A6
Copy down the forumula

[captain73]

Thank you for taking the time to answer, but I'm still, totally, lost. I tried Vlookup, but couldn't get it to work ... i'm trying rank, but again, when it comes to this stuff, i'm not tech savvy. Is there a YouTube video that you would recommend?

[captain73]

If this is about ranking:
=RANK(A1 ; $A$1:$A$6 ; 0)
with points in A1:A6
Copy down the forumula

Been watching video's, and tried you're formula ... all i'#m getting is a 508 Error

[captain73]

Scrap last … i've got it.

Thanks again to the both of you

[Villeroy]

You can't learn any concepts from Youtube or just "by doing". Some things need to be learned from books/scripts/teachers.

Been watching video's, and tried you're formula ... all i'#m getting is a 508 Error

You made a typo.
Copy my formula.
Paste it to any cell outside of A1:A6, say B1.
Enter arbitrary numbers in A1:A6.

[Lupp]

Some years ago I tried to learn a bit from YouTube videos (in a different matter). It was just wasting time. Never again.

You may check the attached example.
If you think you aren't "techy" enough to understand them based on what you could learn from the tutorial you were already pointed to (and the 10-concets-tutorial), from help texts, and from the Function Assistant, you should consider to not use spreadsheets.
I would judge however, you didn't try hard enough.

[captain73]

Rank isn't working how I hoped it would. I wonder if the IF formula … would be a better route.

If, for example, I was looking at horse racing (which I'm not) and I wanted to give a point score for each race where the horse came within the top 5 … would IF be a better way to do it?

[Villeroy]

Even IF the term "IF" sounds familiar to you, IF is the wrong (extremely clumsy) solution to almost anything.

Rank isn't working how I hoped it would.

You still fail to describe your problem.

[captain73]

Even IF the term "IF" sounds familiar to you, IF is the wrong (extremely clumsy) solution to almost anything.

Rank isn't working how I hoped it would.

You still fail to describe your problem.

All I'm trying to do is give the winning position a point score.

The problem with =Rank, is that it's not a way to give the position a point score.

So for example, form of the horse Spotty Dog @ 3.05 at Ludow. The horse last race results. https://www.racingpost.com/profile/hors ... y-dog/form

https://www.racingpost.com/racecards/34 ... 22/796945/

8th
8th
2nd
5th
- Break of over so many days
U - unseated / fell off



All I want to do, and are interested in is whether the horse came within the top 5, and if so, to give that result a point score


1st = 5 points
2 = 4
3 = 3
4 = 2
5 = 1

Of course, i'm not interested if the horse came 8th, I'm only interested if the horse came within the top 5, then it gains the appropriate score. =Rank … doesn't give such a point score, or at least, not the point score i'm needing … if you catch my drift.

BTW, this is not about horse racing!

[captain73]

Forth coming race

Horse - Liberated Lady - https://www.racingpost.com/racecards/10 ... 22/797151/

Result from the past 6 races
5th
3rd
3rd
6th
6th
2nd


I would hope that I could give the point score as follows

5 = 1
3 = 3
3 = 3
6 = 0 - 'cause it falls outside the point score system
6 = 0
2 = 4

[Lupp]

You need to give me a clearly specified (or unmistakably exemplified) format of how the results you want to work with are represented IN A SPREADSHEET. Then I may be able to interpret your additional remarks in a way that I can suggest a solution. Complaining that RANK() doesn't work without telling exactly in what way you tried to use it, wont' help.

Fill some examples into a sheet, create manually the results you expect, store the sheet, and attach it.
That's how it works. I surely won't start with a web site to answer a question about ranking and assigning points in a spreadsheet.

[captain73]

Here goes

[Lupp]

I'm out.
This doesn't lead anywhere. The attached sheet doesn't contain anything new as compared to the original question.
It seems inconsistent in addition with what was posted meanwhile by the questioner.
How to return one of 6 possible values for one of 6 strings using a little lookup table was already demonstrated in my attachment. In addition it contained simpler ways usable if the original rank is given as a number (in place of a string) or first converted to a number.

Hope somebody else does understand better.

[captain73]

I'm out.
This doesn't lead anywhere. The attached sheet doesn't contain anything new as compared to the original question.
It seems inconsistent in addition with what was posted meanwhile by the questioner.
How to return one of 6 possible values for one of 6 strings using a little lookup table was already demonstrated in my attachment. In addition it contained simpler ways usable if the original rank is given as a number (in place of a string) or first converted to a number.

Hope somebody else does understand better.

I thought you would be, as at best, all you've done so far is to throw insults ..


Take care sweetheart!

[Villeroy]

point score system2.ods

(11.43 KiB) Downloaded 207 times

[keme]

You have explained your scoring system in sufficient detail. What is missing is input and output.

Input: How do you have the final outcome(s) recorded in your spreadsheet? Do you simply type in the names of top 6 (or was it top 5) in a designated range somewhere, enter the numbers for those top 6 in a prepared list of participants, or do you have a full result list from which you need to extract the top results?

Output: How do you want the top 6 to appear in your spreadsheet? Extracted to a separate range, tagged/scored within an existing list, or some other way?

Your sample spreadsheet also contains only the scoring system. Villeroy and Lupp made guesses at what the end result might look like, but if their suggestions are not what you are after, you need to show and tell:
Please add illustrating input and output sections to your sample file, to show what you are trying to achieve.
Explanations are welcome. What is obvious to you is not always obvious to your audience (us).