Remove Duplicates in Excel: Tools and Formulas
Discover three easy ways to remove duplicate values in Excel. Our guide provides simple tools and formulas to streamline your data.
UNIQUE
SUMIFS Function in Excel
Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets
Find Items That Appear Only Once
Discover How to Extract Only the Unique Values of a list of data in Excel with the UNIQUE function.
How to return multiple rows with VLOOKUP
If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.
Categories
- Conditional (11)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (15)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (20)
- Lookup functions (14)
- Manage data (20)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (5)
- Shortcuts (5)
- Statistical functions (23)
- Text functions (17)
- Tips and Tricks (21)
