On Sat, 26 Jan 2008 17:55:07 -0000, "Steve" wrote:

I have a several columns of numbers, and I want to calculate the last cell
in the column divided by the first cell in each case (= B300/B1).
However, some columns do not extend all the way back to cell 1. For example,
column F might contain values only from F65 to F300 and so I want to
calculate = F300/F65 in this case. The cells always contain continuous
values when they start.

I want to write a formula to say "F300/highest cell with a value"?

Can anyone suggest a way?

Thanks,

Steve



So long as the only data in the columns are the number entries, then:

=F300/OFFSET(F300,1-COUNT(F1:F300),0)
--ron