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: , , ,