is there a quck formula to identify if any value at all occurs twice within a range?
A Atishoo Sep 25, 2008 #1 is there a quck formula to identify if any value at all occurs twice within a range?
M Mike H Sep 25, 2008 #2 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
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 Sep 25, 2008 #3 how do you want it to be identified...strictly only twice or even more... MikeH had replied and it seems logical.
how do you want it to be identified...strictly only twice or even more... MikeH had replied and it seems logical.
A Atishoo Sep 25, 2008 #4 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
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
