Referencing a series of cells
 

I have a Project Summary form that contains a "Dashboard" tab and 4 other
tabs (Project Scope, Project Status, Project Change, and Project Closure). I
want the dashboard to give viewers a quick snapshot of the project status. I
want the dashboard to reference the Project Status tab and pull the most
recent status update entry into a cell on the dashboard from a series of
individual cells on the Project Status tab. I need help writing the formula
that tells Dashboard cell "X" to go to Project Status cell "B", and if "B" is
empty, pull in the contents of Project Status cell "A", otherwise pull in the
contents of Project Status cell "B", then go to Project Status cell "C", and
if "C" is empty, pull in the contents of Project Status cell "B", otherwise
pull in the contents of Project Status cell "C", then go to Project Status
cell "D", and if "D" is empty, pull in the contents of Project Status cell
"C", otherwise pull in the contents of Project Status cell "D", etc. I
wrote the following formula ( =(IF('3-Project Status'!A36="",('3-Project
Status'!A35),('3-Project Status'!A36))) and this returns the desired result,
but I don't know how to get the formula to keep going down through series of
cells for the last status update entry. Please help me!

Referencing a series of cells
 

Leslie,

If A35 to A56 is filled sequentially and is otherwise empty, this will pull the lowest entry from
that range.

=INDEX('3-Project Status'!A35:A56,COUNTA('3-Project Status'!A35:A56))


HTH,
Bernie
MS Excel MVP


"Leslie" wrote in message
...
I have a Project Summary form that contains a "Dashboard" tab and 4 other
tabs (Project Scope, Project Status, Project Change, and Project Closure). I
want the dashboard to give viewers a quick snapshot of the project status. I
want the dashboard to reference the Project Status tab and pull the most
recent status update entry into a cell on the dashboard from a series of
individual cells on the Project Status tab. I need help writing the formula
that tells Dashboard cell "X" to go to Project Status cell "B", and if "B" is
empty, pull in the contents of Project Status cell "A", otherwise pull in the
contents of Project Status cell "B", then go to Project Status cell "C", and
if "C" is empty, pull in the contents of Project Status cell "B", otherwise
pull in the contents of Project Status cell "C", then go to Project Status
cell "D", and if "D" is empty, pull in the contents of Project Status cell
"C", otherwise pull in the contents of Project Status cell "D", etc. I
wrote the following formula ( =(IF('3-Project Status'!A36="",('3-Project
Status'!A35),('3-Project Status'!A36))) and this returns the desired result,
but I don't know how to get the formula to keep going down through series of
cells for the last status update entry. Please help me!

Referencing a series of cells
 

Bernie -

Your recommendation provided the solution I was looking for to the problem
with my form. I inserted your formula and my form now works as I need it to!


Thank you for taking the time to offer your answer.
Leslie


"Bernie Deitrick" wrote:

Leslie,

If A35 to A56 is filled sequentially and is otherwise empty, this will pull the lowest entry from
that range.

=INDEX('3-Project Status'!A35:A56,COUNTA('3-Project Status'!A35:A56))


HTH,
Bernie
MS Excel MVP


"Leslie" wrote in message
...
I have a Project Summary form that contains a "Dashboard" tab and 4 other
tabs (Project Scope, Project Status, Project Change, and Project Closure). I
want the dashboard to give viewers a quick snapshot of the project status. I
want the dashboard to reference the Project Status tab and pull the most
recent status update entry into a cell on the dashboard from a series of
individual cells on the Project Status tab. I need help writing the formula
that tells Dashboard cell "X" to go to Project Status cell "B", and if "B" is
empty, pull in the contents of Project Status cell "A", otherwise pull in the
contents of Project Status cell "B", then go to Project Status cell "C", and
if "C" is empty, pull in the contents of Project Status cell "B", otherwise
pull in the contents of Project Status cell "C", then go to Project Status
cell "D", and if "D" is empty, pull in the contents of Project Status cell
"C", otherwise pull in the contents of Project Status cell "D", etc. I
wrote the following formula ( =(IF('3-Project Status'!A36="",('3-Project
Status'!A35),('3-Project Status'!A36))) and this returns the desired result,
but I don't know how to get the formula to keep going down through series of
cells for the last status update entry. Please help me!