CHOOSECOLS function in Excel
Discover the power of CHOOSECOLS and how it works with FILTER and GROUPBY functions to enhance data management.
FILTER function
Searchable Dropdown List in Excel
Discover how to build a searchable dropdown list in your Excel workbooks with the FILTER and SEARCH functions.
Compare Two Columns in Excel Easily
Find out how to compare columns in Excel and identify missing values or return only missing values with efficient formulas.
Adding Headers to Tables Built with Dynamic Arrays
Discover the easy way to add headers to dynamic arrays in Excel. This will instantly improve the usability and visual appeal of your data.
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
- AI & Excel (1)
- Conditional (12)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (16)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Quiz Premium (7)
- Shortcuts (5)
- Statistical functions (25)
- Text functions (19)
- Tips and Tricks (21)
