I have a list of five cells which may contain any one of the following
numbers 017, 030,0. In another cell i want to do the following:
If all five cells only contain 017 or 0 then return a value of 017
If all five cells only contain 030 or 0 then return a value of 030
If all five cells contain a combination of all three numbers the cell to
show "Check"
--
tanya