Error Checking for Duplicates in List

[Guest]

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.

 

[Biff]

Hi!

See this:

http://contextures.com/xlDataVal03.html

There's also a sample file link near the bottom of the page.

Biff

 

[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.

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