Hello,
Ive got a question which Im sure has come up before, but I dont know how exactly to phrase it. Ive got a spreadsheet which has data for 100 samples(I work in a lab) listed vertically down the spreadsheet. Each sample has more than one entry and unfortunatly they dont have the same number of entries. What Im trying to do is. I know there are some spaces in the first column between samples. How would I go about sticking a formula in a cell that is down one row and four to the left of the last space? any suggestions?
Thanks
Casey
Ive got a question which Im sure has come up before, but I dont know how exactly to phrase it. Ive got a spreadsheet which has data for 100 samples(I work in a lab) listed vertically down the spreadsheet. Each sample has more than one entry and unfortunatly they dont have the same number of entries. What Im trying to do is. I know there are some spaces in the first column between samples. How would I go about sticking a formula in a cell that is down one row and four to the left of the last space? any suggestions?
Thanks
Casey