How would I select a cell that is above an empty cell? I have a feeling it is going to be something super simple, but I haven't done any excel since 2004.
Here is a simple single column sheet.
data1 data2 data3 data4 data5 data6
I am hoping it would be a function and it should return data2, data4 and data4 in an array of sorts.