Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dwight at Boeing
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting unique entries in column A but only if specific values appear in columns B and C markx Excel Worksheet Functions 1 February 10th 05 12:52 PM
find rows for unique data in 1 column and different data in other. Dot Majewski Excel Discussion (Misc queries) 1 January 21st 05 01:23 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
count data but avoid double entries Manos Excel Worksheet Functions 1 December 14th 04 08:00 AM
How do I count or display unique data in a column? kbeilers Excel Worksheet Functions 1 November 12th 04 05:51 AM


All times are GMT +1. The time now is 07:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"