I have a range of 5 cells. These cells can contain a blank, or a number (the
numbers are 1,2,3,4 and 5). Numbers cannot repeat within the range (i.e. if
there is a 1 in a cell, the 1 cannot occur in any of the other 4 cells).

With the cursor in the first cell, how can I have Excel determine whether
there is a 1 in any of the other 4 cells; then determine whether there is a 2
in any of the other 4 cells; then determine whether there is a 3, etc? There
has to be some way, other than trying to write a super-complex IF statement.
Do you have any ideas?

--
John