Hello,
I'm trying to highlight some data on a table depending if the value of DB_VehMat is present in a consecutive day.
| BD_date | DB_VehMat |
|---|
| 01/01/2016 | 123aze |
| 01/01/2016 | 456qsd |
| 01/01/2016 | 789wxc |
| 02/01/2016 | 123aze |
| 02/01/2016 | 896edc |
| 02/01/2016 | 963tgj |
| 03/01/2016 | 123aze |
| 03/01/2016 | 456qsd |
| 03/01/2016 | 963tgj |
In this exemple, if DB_VehMat is present the next day, I'd like the first one to be highlight in red.
If the DB_VehMAT is there during 3 consecutive days, I'd like to highlight the first 2. (and so on ...)
Ergo, the result should be something like this :
| BD_date | DB_VehMat |
|---|
| 01/01/2016 | 123aze |
| 01/01/2016 | 456qsd |
| 01/01/2016 | 789wxc |
| 02/01/2016 | 123aze |
| 02/01/2016 | 896edc |
| 02/01/2016 | 963tgj |
| 03/01/2016 | 123aze |
| 03/01/2016 | 456qsd |
| 03/01/2016 | 963tgj |
I think the best way to solve this problem is with the Set Analysis but I can't manage to write a expression which is working as expected.
According to me, the solution should be something like this :
=if(DB_VehMat = "... I need help day+1 ...",red())
Thanks a lot for helping.
S.Colaux
