Hi Dave,
I'll try to describe it better.
I have columns like
F J
data1 data2
(empty)data3
(empty)data4
(empty)(empty)
data5 data6
(empty)data7
(empty)data8
(empty)data9
(empty)(empty)
My result must look like:
F J
data1
Hi George,
Can't quite understand your request.
column F down untill we reach two empty cells in columns F and J
But your sample data doesn't have 2 empty cells in both F and J.
Perhaps you could attach a sample workbook with a bit more data - say 20 rows.
Regards - Dave.
Date: Fri, 29 May 2009