match

A

Atishoo

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

Mike H

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
 
D

driller

how do you want it to be identified...strictly only twice or even more...
MikeH had replied and it seems logical.
 
A

Atishoo

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
 

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

Tagging Misspell Words with "##" 0
match formula 2
Macro to select and delete levels of a document 2
Match issue 3
Match second occurance of value 6
IF ARRAY with multiple conditions. 1
Vlookup & return multiple unique values 14
Outlook Quick Click categories on a shared mailbox. 2

Top