Excel People

[RobinRobin 5303]

[wykikitoon 10969]

Right G-Dogg & F-Mann.

I am trying to figure out the best way to do this one.  We have a race league that is held weekly throughout the summer months.  You get a set number of points per participation.  Not everyone competes every week due to other commitments etc.  I want the easiest way of working out total points with the least amount of manual imputing as possible.

[Gemmill 24324]

You need to provide more details. Framework of a spreadsheet or whatever. This is too broad a request as it is, you PENIS.

[wykikitoon 10969]

15 minutes ago, Gemmill said:

You need to provide more details. Framework of a spreadsheet or whatever. This is too broad a request as it is, you PENIS.

 

We have a weekly event and basically I need to total up the points  

 

At the moment I have;

 

 

 

So we give 10 points per ride.  So in this instance Rider A would have a total of 30 points.

Edited Friday at 08:03 by wykikitoon

[Gemmill 24324]

1 minute ago, wykikitoon said:

 

We have a weekly event and basically I need to total up the points  

 

At the moment I have;

 

 

 

So we give 10 points per ride.  So in this instance Rider A would have a total of 30 points.

 

Just do a COUNTIF multiplied by 10.

 

So have a separate table with just rider names and then a COUNTIF for each of them.

[wykikitoon 10969]

7 minutes ago, Gemmill said:

 

Just do a COUNTIF multiplied by 10.

 

So have a separate table with just rider names and then a COUNTIF for each of them.

<gif> You're the man </gif> 

[Gemmill 24324]

5 minutes ago, wykikitoon said:

<gif> You're the man </gif> 

 

BTW to arrive at your list of rider names, don't do that manually. Use the following:

 

=UNIQUE()

 

And the range in the brackets should be the name column from your previous screenshot. That way you don't have to keep adding new people to your score table.

 

You can wrap your UNIQUE() in a SORT() as well if you want it sorted alphabetically.