Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(AND(MAX(MAX(IF(Tableau2[Serial Number]=[@[Serial Number]];
- Tableau2[Arrival Date];"")))>MAX(MAX(IF(Tableau3[Serial Number]=[@[Serial Number]];Tableau3[Installation Date];"")));
- MAX(MAX(IF(Tableau2[Serial Number]=[@[Serial Number]];
- Tableau2[Arrival Date];"")))>MAX(MAX(IF(Tableau4[Serial Number]=[@[Serial Number]];
- Tableau4[Fail Date];""))));"Warehoused";IF(AND(MAX(MAX(IF(Tableau3[Serial Number]=[@[Serial Number]];Tableau3[Installation Date];"")))>MAX(MAX(IF(Tableau2[Serial Number]=[@[Serial Number]];
- Tableau2[Arrival Date];"")));
- MAX(MAX(IF(Tableau3[Serial Number]=[@[Serial Number]];
- Tableau3[Installation Date];"")))>MAX(MAX(IF(Tableau4[Serial Number]=[@[Serial Number]];
- Tableau4[Fail Date];""))));"Installed";"Had a defect/Sent for repair")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
