Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to report the current phase of a project
I am working on a spreadsheet where each person has their own project and
each project has 7 different phases. I would like the spreadsheet to look down the percentage complete column and find the first <100% and report the project title in that row as the current phase even if they are working on multiple phases. They may be 100% with the 4th phase but if they havent finished the 2nd phase then that is the current phase to report to the executives. So I guess I am looking to have it count the column and the first non =100% it comes across, report it and it alone. When they finish that phase, it will go onto the next one. When all of the phases read 100%, I would like for it to refer to a different cell that reads, "Complete" I hope this makes sense to somebody. I am thinking I need a If True if False formula but I am not sure how to formulate it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use the current row in a list to populate a report | Excel Worksheet Functions | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
group by report | Excel Discussion (Misc queries) | |||
Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) |