Are you asking if this works?

=INDEX(6:6,COUNTA(6:6)-1)

yes it does as long as you have all cells filled from A6 to wherever your
range ends


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"t johnson" wrote in message
...
hi peo
i entered the formula changing the A1:A30 values to 6:6 as i am checking
rows not columns (hope this is correct) but the formula cell just shows 0
incidentaly if i click the fx button to display workings of the formula
the
sum of cells is correct
is there some formatting that i have to do to the cells or an option i
need
to enable for the formula to display the correct result
thanks in advance


"Peo Sjoblom" wrote:

If you want the second but last value and there are no blank cells before
that last cell

=INDEX(A1:A30,COUNTA(A1:A30)-1)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"t johnson" <t wrote in message
...
am trying to shedule using excel :-)
in row 2 i have used today() then in next column workday(prev
colum,1)and
copied this across the length of the row to get my calender
in the following rows i have put the job operations
using formula i want to find the last cell in each row with data and
then
if
possible using the offset function get the date my job is predicted to
finish
from row 2 above this last cell in each row Phew!!
hope this makes sense