Ok........

If any bus number can appear in any cell on any row.........

I have a list of buses numbered something like this 320-360, 700-750,
800-899, 900-990.

800-899, 900-990

That is one continuous range so:

Assume the entire range is A1:E5

Select that range
Goto DataValidation
Allow: Custom
Formula:

=AND(OR(AND(A1=320,A1<=360),AND(A1=700,A1<=750), AND(A1=800,A1<=990)),COUNTIF($A$1:$E$5,A1)<2)

Biff

"dgraham" wrote in
message ...

Hi Biff,

Hope we can, no the buses can end up anywhere in the shed (row).

As they are put away by the refuelers i would go and enter them where
they have been parked.

regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile:
http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=529481