Excel Dropdown list – Exclude Previously Selected Items
To avoid duplicate selections in dropdown lists, learn how to exclude previously selected items using the COUNTIF and FILTER functions.
Duplicates
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
Keep your Last Updated Data
In some cases, remove duplicate doesn't help you to keep the last value. This tutorial will show you how you can solve this.
Anonymize your data
Discover how you can transform your worksheet to anonymise your data in the case you have sensitive data. 5 steps are needed
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)
