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
How to use the FILTER function in Excel? The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365