I have a sheet with data as under. In between there are blank rows without data. I want to get the first cell value in each coloumn which is the value just below the last blank cell)
here for eg: Here the last part is From March 11. For Coloumn "B" I want to get the value (-1.43) and For Col. "C" -2.16, so on... If my question is confusing, i can attach the spreadsheet.
I am looking for a formula, not a VB Code. Any help will be highly appreciated. thanks a lot.
Mac
A B C
Feb 21 2.47 0.65
Feb 24 -4.84 -2.97
Feb 25
Feb 26 -4.52 -1.00
Feb 27 -0.72 0.27
Feb 28 0.71 -0.77
Mar 03 -1.57 -0.51
Mar 04 -1.19 -0.48
Mar 05
Mar 06 -5.11 -1.69
Mar 07 2.60 -0.57
Mar 08
Mar 11 -1.43 -2.16
Mar 12 0.51 0.07
Mar 13 5.64 3.22
Mar 14 -0.48 2.60
Mar 15 -0.15 3.17