reference for last used cell in row

[Guest]

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

 

[Peo Sjoblom]

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)

 

[Guest]

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]

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)