Posted 22 October 2007 - 03:00 AM
Let's assume you're using Microsoft EXCEL. I'd do that job with a combination of formulas and functions.
Suppose you put your team names in cells A1 to F1, top left of the spreadsheet, and their result positions on the row below, in cells A2 to F2.
Essentially you want to warn the user not to re-use a position. Excel is not good with messages, but a warning row (cells B3 to F3) could work. In cell B3 enter the formula [ =IF(ISERROR(MATCH(B2,$A2:A2,0)),"",MATCH(B2,$A2:A2,0)) ] without the square brackets, of course. Copy-paste that formula into cells C3 to F3. Then, as you fill in results, row 3 will list the column number of any previous use, wherever it finds a "MATCH".
If you wanted to make a bigger fuss about an error, put a conditional format on Row 3, say, a glaring background behind any MATCH number. Suppose in Cell B3 your conditional format was set for Cell value is Between 1 and 5, and the format is a warmish Pink, that should catch attention. Again, copy cell B3 into C3 to F3.
Oh, you did mention1 to 6 (or 1st to 6th). That would require a second conditional format. In B3, this would read: Formula is =(OR(B2<1,B2>6) , and the same gaudy format if you want to keep it simple. Again, copy the format of cell B3 into C3 to F3, but this time also into A3, because the operator CAN stuff up there too.