Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to validate data entries to be unique within an array
I am using a worksheet to track channel assignments for a data acquisition
system. The sheet has an array of cells which define by rows the input cards in the system. The columns are the channels for each card. The entries are short mnemonics which identify which signal is connected to a particular channel. I would like to make sure that the same signal name cannot be entered twice in the array. This validation would assist in relocating signals if the system has to be reconfigured and would assist in assigning signal names to new proposed signals. Can an array of cells be selected and a validation check applied to make sure that only one occurence of a data entry is made within the array? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
count data but avoid double entries | Excel Worksheet Functions | |||
How do I count or display unique data in a column? | Excel Worksheet Functions |