match

  • Thread starter Thread starter Atishoo
  • Start date Start date
A

Atishoo

is there a quck formula to identify if any value at all occurs twice within a
range?
 
One way,

Select the column of data then
Format|Conditional format
Formula is
=COUNTIF($A$1:$A$1000,A1)>1
Pick a colour.
OK

Duplicates will be highligted.

Mike
 
how do you want it to be identified...strictly only twice or even more...
MikeH had replied and it seems logical.
 
doesnt matter because as soon as it occurs twice I want to trigger a user
form that will say " youve already made the same selection choose again" or
words to that effect
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
match formula 2
2007 Word Quick Access Printer Icons 1
Match second occurance of value 6
Vlookup & return multiple unique values 14
returning text; alternative to sumproduct/sumif? 4
Lookup returning wrong results 0
duplicate occurance, assigning an ordinal value 14

Back
Top