The 10 most useful Excel Functions
What are the 10 most useful Excel functions that you need to know? This article presents them with examples.
FILTER function
Find duplicate values in Excel by formula?
Unlock the secrets of finding duplicate values in Excel effortlessly. Find out how to use FILTER and COUNTIF functions
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
Categories
- Conditional (11)
- Conditional Formatting (18)
- Date (47)
- Dynamic Arrays (8)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (15)
- Expert (30)
- Finance (5)
- Free Excel Tutorial for beginners (32)
- Function (2)
- Intermediate Excel Skills: Tutorials and Articles (24)
- Lookup functions (14)
- Manage data (22)
- Maps and GPS (4)
- Pivot Table (7)
- Power Query (5)
- Shortcuts (5)
- Statistical functions (23)
- Text functions (18)
- Tips and Tricks (23)
