Excel Expert
Enter formular in excel , to automatically fill in Error Type in column "M", based on the Error number gotten from column "C"(Warning).
ERROR TYPES OPTIONS
1. Adbom
2. Duplicate
3. Adbom&Serv
4. Adbom&Duplicate
5. Adbom&Serv&Duplicate
6. Serviceable
7. Pairs Files
If 2100 or 2122= Adbom
2129 or 2182=Duplicate
2107 and 2122 are both in row= Adbom & Serv
2100+ 2182+2129=Adbom&Duplicate
Both -2100+2182+2107 +2129 = Adbom&Serv &Duplicate
2107=Serviceable
215 or 240 or 2134 or 2101 or 2102= Pairs Files