I’m using this formula in cell b1639 =COUNTIF($A$2:$A$3000,$A1639)
to test for duplicates in the range a2:a3000. Currently no match returns a value of 1 and a match returns a value of 2.
Can the formula be revised using the address function as part of the formula to return a cell number of a match?
Maybe I am using the wrong function altogether. If so, I certainly will change it if someone can suggest a better option.