| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I prevent duplicate numbers in a range of validated cells?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Ranges using non-contiguous cells and dependent on a cell value | Excel Worksheet Functions | |||
| two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| How do you prevent users from pasting over validated cells? | Excel Discussion (Misc queries) | |||
| How do i get the top 5 numbers in a range of cells? | Excel Worksheet Functions | |||
Hybrid Mode
