S
Suzanne
Greetings. On one tab i have several projects (taking approx 6 columns each),
each having several rows beneath with project steps. The project steps each
have a corresponging Status colum (column to the right of the step).
I've constructed a summary tab that returns certain hi level data elements
for each project (using hlookup). However, i'd like to include a current
status column in the summary tab, for each project. Assuming the current
status is the last status listed in the status column, how to i return that
value to the summary tab? Hope someone out there can help. Many thanks.
Formula for
summary tab this column? project tab
Start Status Proj1
Proj2
Proj1 2/1/07 On schedule Start: 2/1/07 Start:
3/3/07
Proj2 3/3/07 Behind schedule Step1: On schedule Step1: Behind
schedule
Step2: Behind schedule
Step2: On schedule
Step3: On schedule
Step3: Behind schedule
each having several rows beneath with project steps. The project steps each
have a corresponging Status colum (column to the right of the step).
I've constructed a summary tab that returns certain hi level data elements
for each project (using hlookup). However, i'd like to include a current
status column in the summary tab, for each project. Assuming the current
status is the last status listed in the status column, how to i return that
value to the summary tab? Hope someone out there can help. Many thanks.
Formula for
summary tab this column? project tab
Start Status Proj1
Proj2
Proj1 2/1/07 On schedule Start: 2/1/07 Start:
3/3/07
Proj2 3/3/07 Behind schedule Step1: On schedule Step1: Behind
schedule
Step2: Behind schedule
Step2: On schedule
Step3: On schedule
Step3: Behind schedule