shaktimair
New Member
- Joined
- Dec 7, 2017
- Messages
- 3
Hello all
This is my first post on this forum and needed some help on what I am trying to do.
I have data that stretches across a few cells and shows the grade the advisor received in date order and the formula I am trying to build is to check they competency rating and I want the formula to look at each row and soon as it finds 'Red Agree' in a cell to mark as 'Action Required' but if after that 'Red Agree' grade they get 3 consecutive 'Green Agree' then make it 'No Action Required'
I hope this is enough information, however please advise if any more details required.
I have a project at work and really need someone's help, many thanks in advance for your time.
Regards
Shakti Mair
Example below:
Top one - As 3 greens after the red = No Action Required
Bottom one - As 3 greens after red = Action Required
<tbody>
</tbody>
This is my first post on this forum and needed some help on what I am trying to do.
I have data that stretches across a few cells and shows the grade the advisor received in date order and the formula I am trying to build is to check they competency rating and I want the formula to look at each row and soon as it finds 'Red Agree' in a cell to mark as 'Action Required' but if after that 'Red Agree' grade they get 3 consecutive 'Green Agree' then make it 'No Action Required'
I hope this is enough information, however please advise if any more details required.
I have a project at work and really need someone's help, many thanks in advance for your time.
Regards
Shakti Mair
Example below:
Top one - As 3 greens after the red = No Action Required
Bottom one - As 3 greens after red = Action Required
Check Grade 1 | Check Grade 2 | Check Grade 3 | Check Grade 4 | Check Grade 5 | Outcome | |
10/11/2017 | 11/11/2017 | 12/11/2017 | 13/11/2017 | 14/11/2017 | ||
Red Agree | Green Agree | Green Agree | Green Agree | Green Agree | No Action Required | |
Green Agree | Green Agree | Red Agree | Green Agree | Green Agree | Action Required |
<tbody>
</tbody>