hmltnangel
Active Member
- Joined
- Aug 25, 2010
- Messages
- 290
- Office Version
- 365
- Platform
- Windows
Hi excel peoples! One that I think should be so easy but my brains frazzled today. Its the blanks in the Staff ID column that are throwing me off
Column "A" has a list of Staff IDs. This ID number shows once for any employee, the next cells in the column are blank until the next staff id
A1 has staff id 1234567, a2-a5 are blank, then a6 will be the next one 1234568 and so on
Then Column B shows Sales Status on each row, "incomplete", "complete", "not started"
I want column C to show the worst overall status for any of the that employees sales as below.
Any help
Column "A" has a list of Staff IDs. This ID number shows once for any employee, the next cells in the column are blank until the next staff id
A1 has staff id 1234567, a2-a5 are blank, then a6 will be the next one 1234568 and so on
Then Column B shows Sales Status on each row, "incomplete", "complete", "not started"
I want column C to show the worst overall status for any of the that employees sales as below.
Any help
Staff ID | Completion | Overall |
1234567 | Complete | Incomplete |
Not Complete | ||
Complete | ||
Complete | ||
1234568 | Complete | Not Started |
Not Started | ||
Complete | ||
Complete | ||
1234569 | Complete | Complete |
Complete | ||
Complete | ||
Complete | ||
12345689 | Complete |