Hi everyone,
I have a list that has blank rows mixed in. I'd like to return a list without those blank rows to be used as a dropdown menu for a budgeting tool.
I tried using the offset formula from the link below but this just cut off my list after the first blank rows showed up.
http://www.excelforum.com/excel-gene...ank-cells.html
My current list looks something like this:
Code
5000-Salary
5000-01 - Hourly
6000-Supplies
7000-Travel
8000-Contractors
Bookmarks