Hello,

I am trying to validate user entry in a cell that prohibits them from
entering the same number as any number in a range of cells. For example, I
want the entry in A1 to not equal A2,A3, or A4. I also do not want A2 to
equal A1,A3, or A4 and so on. When ion the data validation window I select
"not equal to" and then it won't let me enter a range of cells no matter how
many different ways I try. There has to be a way of doing this. Suggestions?
Thanks a lot.