JoaoGabriel
New Member
- Joined
- Jun 6, 2021
- Messages
- 15
- Office Version
- 2019
- Platform
- Windows
I'm trying to create a macro that identifies with 1 when there is a error which follows two conditions:
1) if the value is SUPRESSED: the next value in the same row have to be SUPRESSED or CONNECTED
2) if the value is FEASIBLE: the next value in the same row have to be FEASIBLE or CONNECTED and before a FEASIBLE value there can be no value beyond FEASIBLE
Ignoring blank cells in both cases and fill with 0 when the error doesnt occur. I tried to create some macros but couldn't ignore blank values and apply to multiple lines at once.
The data looks like this and the error column is the expected result:
Can anyone help?
1) if the value is SUPRESSED: the next value in the same row have to be SUPRESSED or CONNECTED
2) if the value is FEASIBLE: the next value in the same row have to be FEASIBLE or CONNECTED and before a FEASIBLE value there can be no value beyond FEASIBLE
Ignoring blank cells in both cases and fill with 0 when the error doesnt occur. I tried to create some macros but couldn't ignore blank values and apply to multiple lines at once.
The data looks like this and the error column is the expected result:
Can anyone help?