Data Validation

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

Update 12/12/2021 Since writing this post in 2017, Excel now has new revolutionary dynamic array formulas that really has overtaken all the workarounds for better dropdown lists we used to do such as described in my post below.  Now the new formula SORT() + UNIQUE() in Excel Office 365 (although not in earlier stand alone …

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