Question: what is the formula to find duplicates in excel?
Answer: If you need to find duplicates in a range of cells rather than in an entire column, remember to fix that range by using $. For example, to search for duplicates in cells A2:A8, use the formula =COUNTIF($A$2:$A$8, A2)>1.