I have a list of cells all in the same column(33 of them). Individuals have to rank each cell that corresponds to a task beside the cell. I need to check the range each time the individual enters a value from 1-33 on each cell that there is no duplicates that exist. If there is, then a Message box would appear stating "Number already Used", with just "OK" from the Message box, but not letting individual go to another cell until condition is cleared.
Any help would be greatly appreciated.