Spreadsheet: 699334d1602538161-how-to-find-consecutive-3-days-and-2-days-particular-customer-is-red-data-1-
Sheet: Sheet2

 |  |  |  | Matrix 1 |  | Matrix 2 |  | Matrix 3
Customer | Metric-1 | Metric-2 | [NAME] | 3 Days | 2 Days | 3 Days | 2 Days | 3 Days | 2 Days | Overall Red
3111 | Red |  | Green | Yes | Yes |  |  |  |  | Yes
3114 | Red |  | Green | Yes | Yes |  |  |  |  | Yes
3897 | Red |  | Green | Yes | Yes |  |  |  |  | Yes
302 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
303 | Green | Red |  |  |  | Yes | Yes |  |  | Yes
304 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
305 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
355 | Green | Red | Green |  |  |  | Yes |  |  | Yes
374 | Green | Amber | Green |  |  |  | Yes |  |  | Yes
375 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
377 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
471 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
660 | Green | Red |  |  |  | Yes | Yes |  |  | Yes
667 | Green | Red |  |  |  |  | Yes |  |  | Yes
1627 | Green | Amber | Green |  |  |  | Yes |  |  | Yes
1642 | Green | Amber | Green |  |  |  | Yes |  |  | Yes
1691 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
1692 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
1882 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
1902 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
1997 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2038 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2040 | Green | Amber | Green |  |  |  | Yes |  |  | Yes
2061 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2063 | Green | Red | Green |  |  |  | Yes |  |  | Yes
2064 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2075 | Green | Red | Green |  |  |  | Yes |  |  | Yes
2076 | Green | Red | Green |  |  |  | Yes |  |  | Yes
2079 | Green | Red | Green |  |  |  | Yes |  |  | Yes
2144 | Green | Red | Green |  |  |  | Yes |  |  | Yes
2352 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2420 | Green | Red | Green |  |  |  | Yes |  |  | Yes
2486 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2784 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2785 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2786 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2789 | Green | Amber | Green |  |  | Yes | Yes |  |  | Yes
2840 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2841 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2843 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2847 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
2848 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
1519 | Red | Green | Green |  | Yes |  |  |  |  | Yes
3141 | Green | Red | Green |  |  |  | Yes |  |  | Yes
3235 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3286 | Green | Red | Green |  |  |  | Yes |  |  | Yes
3293 | Green | Amber | Green |  |  |  | Yes |  |  | Yes
3294 | Green | Amber | Green |  |  |  | Yes |  |  | Yes
3301 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3303 | Green | Red | Green |  |  |  | Yes |  |  | Yes
3315 | Green | Amber | Green |  |  |  | Yes |  |  | Yes
3321 | Green | Red | Green |  |  |  | Yes |  |  | Yes
3330 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3332 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3362 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3376 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3385 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3605 | Green | Amber | Green |  |  | Yes | Yes |  |  | Yes
3610 | Green | Amber | Green |  |  | Yes | Yes |  |  | Yes
3663 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3665 | Green | Red | Green |  |  |  | Yes |  |  | Yes
3667 | Green | Amber | Green |  |  | Yes | Yes |  |  | Yes
3698 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3699 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3700 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3710 | Green | Red | Green |  |  |  | Yes |  |  | Yes
3726 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3732 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3734 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3781 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3782 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3783 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3784 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3786 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3788 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3790 | Green | Red | Green |  |  |  | Yes |  |  | Yes
3791 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3792 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3794 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3796 | Green | Red | Green |  |  |  | Yes |  |  | Yes
3823 | Green | Red | Green |  |  |  | Yes |  |  | Yes
3825 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3930 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
3933 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
4023 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
4024 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
4025 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
4026 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes
4031 | Green | Red | Red |  |  | Yes | Yes |  |  | Yes
4032 | Green | Red | Red |  |  | Yes | Yes |  |  | Yes
4033 | Green | Red | Red |  |  | Yes | Yes |  |  | Yes
4035 | Green | Red | Green |  |  | Yes | Yes |  |  | Yes