How to find duplicate values in Excel? You can easily find all your duplicate values in a column with a simple formula and 2 Excel functions; FILTER and COUNTIF