The example on my first post should have looked like this:

score.....................1 2 3 4 5 6 7 8 9 10
description here........................x.............

"geoffw" wrote:

I have a spreadsheet where i have cells that asign a score of 1 to 10 to a
description by placing an 'x' in the appropriate cell, like this:

1 2 3 4 5 6 7 8 9 10
description here x

The above would score the description 7 out of a maximum 10.

I would like all the other possible scores for that description to
automatically become blank depending on where you place the 'x' - at the
moment you can place an 'x' in all the boxes at once which allows the
description to score 100 out of 10!

So if I changed the above example by putting an 'X' under number 9 the one
under number 7 would disappear.

I'm an Excel novice - any help appreciated.