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
FILTER function
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
