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 an important practical feature to make your spreadsheets more usable, enable faster more consistent input and robust.   Data Validation Dependent Dropdowns are dropdowns which change according to a another dropdown choice.  For example if I …

Dependent Dropdown using INDEX Read More »

Tagged with: ,