Error Checking for Duplicates in List

B

bman342

Users will be entering a list of data across a row. They will be selecting
the datum from a "validated" drop-down.
We need to ensure that they don't select any duplicate entries from the
drop-down when completing their list.
I researched a 'Conditional Formatting' solution that will change the
formatting. I tried this, but when I tried to copy the Formatting on
pre-existing lists, I could not get it to not copy the Value as well(?).
Any suggestions for checking and flagging duplicates in a list?
Thanks in advance.
 
F

Franz Verga

Nel post *bman342* ha scritto:
Users will be entering a list of data across a row. They will be
selecting the datum from a "validated" drop-down.
We need to ensure that they don't select any duplicate entries from
the drop-down when completing their list.
I researched a 'Conditional Formatting' solution that will change the
formatting. I tried this, but when I tried to copy the Formatting on
pre-existing lists, I could not get it to not copy the Value as
well(?). Any suggestions for checking and flagging duplicates in a
list?
Thanks in advance.
Click to expand...

You can see Chip Pearson site's:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates



--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top