reference for last used cell in row
 

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

reference for last used cell in row
 

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

reference for last used cell in row
 

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

reference for last used cell in row
 

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