Need to make cells to have multiple values

[JRS086]

Hi Team

I need help. I am doing a spreadsheet for a race regatta. I have all the entrants on a separate sheet and have linked this back to appropriate cells with the data validity function.

My Issue is that I need to add a value to these entrants to work out points based on if they come first,second,third etc

I would also need these total values to be populated to a separate cell to show the total for each entrant. I am struggling that the cell range that has been selected for entrant list will not also let me assign a numerical value as well.

Any Help would be much appreciated.

Cheers

[robleyd]

I need to add a value to these entrants to work out points

Perhaps you could use a lookup table? It’s not exactly clear to me exactly what you are trying to do. A sample spreadsheet - not a picture - with more specific information might help us to help you.

[keme1]

@JRS086

Need to make cells to have multiple values

That is not possible in a spreadsheet. Cell content is strictly “atomic”.

@JRS086

I have all the entrants on a separate sheet and have linked this back to appropriate cells with the data validity function.

As long as the heat result lists constitute a contiguous grid and the vessel names cannot be mistaken for points scored, you can probably use a “cheat”; a formula that spans all columns using a single SUMIF().

See attached sample.
scoring.ods (9.2 KB)