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
Keep the latest updated value for each client in Excel: UNIQUE lists the clients, MAXIFS finds the last date, FILTER returns the full row.
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
- 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)
