- Jul 8, 2003
As you can see the first column has blank rows of data. I need a formula that will create a series without blanks like I have in the second column. The data in the first column will constantly change so a trick like filtering, and then selecting visible cells only won't work in this case. There will never be more than one empty row between the values in the first column. I really need a formula to make this work. Thanks.