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
FILTER function
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
The 10 most useful Excel Functions in 2023
What are the 10 most useful Excel functions that you need to know? This article presents them with examples.