Board index » Excel » Referencing a series of cells

Excel27
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!


-

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" <Leslie@discussions.microsoft.com>wrote in message



-

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: