I know this should be easy but I am struggling here.
I need custom data validation in a range of 5 cells to allow only whole numbers between 1 and 5 AND to not permit duplicates. (This is for ranking).
I just can't get the syntax right.
Thanks for any help.
Bookmarks