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
You can easily find all your duplicate values in a column with a simple formula and 2 Excel functions; FILTER and COUNTIF
What are the 10 most useful Excel functions that you need to know? This article presents them with examples.