Countif

[Steved]

Hello from Steved

I have a Formula that looks for a double up in column A
=countif($A$1:$A$800,A1)
What this does is puts the value 1 in column B and if it
finds 2 it puts the value 2
Ive over 750 rows so i have to scroll down all the rows
until everything is okay or I find the value 2

Question can I add to the formula that if it finds the
value 2 in Column B it goes to it.

ps yes I am aware I could use the find

Thankyou.

 

[JMay]

Why not engage auto-filter and in ColB, use Custom "greater than or = 2"?

 

[Steved]

I did just as explained and thats what I wanted.

Thankyou.