How do I prevent duplicate numbers in a range of validated cells?

S

sonyawheatley

I have a validation rule for a series of cells. The 3 cells are only
allowed to have a value of 3, 5, or 1. I want to fix it so that each
number may only be used once in a range of 3 cells. .... So in A1:A3,
each number may only appear once or an error message pops up or the
cell starts blinking ~ something needs to happen to notify the user
that there is an error that needs correcting.


THanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
Page numbering with Merged Document and IF statements 1
Automatically chnage number format of a range of cells 2
Preventing Duplicate Records 2
Count in a range of numbers 9
Multiple condition message box 1
How do I exclude a cell from a range? 4
Looking to added up based on a character from cell range 1

Top