Category: Data Validation

Do you find that some dialogs like the Name Manager and the Data Validation dialog mess you around when you edit or enter formulas?  I call this the Excel Dialog Box Muddle!  For years and years now these two dialogs …

Excel Dialog Box Muddle Read More »

Tagged with: ,

Up until quite recent versions of Excel (I am guessing a little here because I only have Office 365 so always have the latest and forget when I discovered this) if you wanted a dynamic list for your Validation Dropdowns, …

Validation Dropdown lists based on Table Columns ranges Read More »

Tagged with: , , ,

Sometimes you just need to get rid of the gaps in lists!  Perhaps you want to use the list for a validation dropdown and you want no gaps in the list so it’s easier to use.  Perhaps you just want …

No more gaps – a formula to remove spaces in lists or empty rows in ranges Read More »

Tagged with: , , ,

Data Validation Dependent Dropdowns are important practical feature to make your spreadsheets more usable and robust.   Data Validation Dependent Dropdowns are dropdowns which change according to a another dropdown choice.  For example if I have a data set with say …

Dependent Dropdown using INDEX Read More »

Tagged with: ,