Firstly thanks for looking and secondly i hope this makes sense!

I am making a 'sports day' spreadsheet for a project and i have one problem, the spread sheet is meant to have the possiblitlity of mistakes reduced to a minimum.

I have 6 teams in the sports day and under each i put 1st, 2nd,3rd,4th,5th,6th.


http://pic16.picturetrail.com/VOL692.../274845201.jpg




basically i need the rows to only accept 1st 2nd 3rd..... only once. I need something like an error message to come up if a value is entered twice on a row.

I hope this makes sense. Please help, is it possible, if so how? or am i just looking for something that isnt there?

pelase help asap! sorry i have posted this on another board on the forum because i didnt realise this board