Spreadsheet: 822351d1679297783-filter-function-nested-if-multi-better-simpler-expression-stephanrs_20230320
Sheet: DATA

MAKE | MODEL | FUEL | TYPE | DESC | IG |  | UNIQUE MAKE |  | Formula SRCH Col A | Formula SRCH Col B | Formula SRCH Col C | Formula SRCH Col D |  | 1BOX |  |  |  |  |  |  |  | 2BOX |  |  |  |  |  |  |  | 3BOX |  |  |  |  |  |  |  | 4BOX |  |  |  |  |  |  |  | BLANK |  | 3 series | DIESEL | Tdi | Nice | 10
Peugeot | 2O7 | PETROL | Gti | OK | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bmw | Z4 | PETROL | Sport | Great | 15
Peugeot | 3O6 | DIESEL | TD | [NAME] | 13 |  |  |  | Renault | Megane |  | CDTi |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bmw | X4 | PETROL | 4WD | 4x4 | 16
Honda | Civic | PETROL | Type R | [NAME] | 13 |  |  |  |  |  |  | Club |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bmw | 3 series | DIESEL | Tdi | Nice | 10
Fiat | Panda | PETROL | Dlux | Poor |  |  |  |  |  |  |  | Dci |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bmw | 3 series | DIESEL | [NAME] | Nice | 10
Citreon | Ax | PETROL | Vibe | Poor |  |  |  |  |  |  |  | Dlux |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Citreon | Ax | PETROL | Vibe | Poor | 0
Vauxhall | Nova | PETROL | SRI | Dull | 8 |  |  |  |  |  |  | GT Hdi |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fiat | Panda | PETROL | Dlux | Poor | 0
Rover Metro | Metro | PETROL | Club | Dull |  |  |  |  |  |  |  | Gti |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fiat | Punto | PETROL | Sport | Tidy | 8
Peugeot | 3O7 | DIESEL | Hdi | [NAME] | 11 |  |  |  |  |  |  | Hdi |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ford | Focus | DIESEL | TDCi | Great | 11
Peugeot | 2O6 | DIESEL | Hdi | [NAME] | 7 |  |  |  |  |  |  | Sport |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Honda | Civic | PETROL | Type R | [NAME] | 13
Bmw | 3 series | DIESEL | Tdi | Nice | 10 |  |  |  |  |  |  | SRI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Honda | Civic | DIESEL | CDTi | Great | 10
Bmw | Z4 | PETROL | Sport | Great | 15 |  |  |  |  |  |  | TD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Honda | Civic | DIESEL | CDTi | Excellent | 10
Bmw | X4 | PETROL | 4WD | 4x4 | 16 |  |  |  |  |  |  | TDCi |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peugeot | 2O7 | PETROL | Gti | OK | 15
Renault | Megane | DIESEL | Dci | Great | 8 |  |  |  |  |  |  | Tdi |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peugeot | 3O6 | DIESEL | TD | [NAME] | 13
Proton | Impian | PETROL | Sport | Dull | 8 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peugeot | 3O7 | DIESEL | Hdi | [NAME] | 11
Ford | Focus | DIESEL | TDCi | Great | 11 |  |  |  |  |  |  | Type R |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peugeot | 2O6 | DIESEL | Hdi | [NAME] | 7
Honda | Civic | DIESEL | CDTi | Great | 10 |  |  |  |  |  |  | Vibe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peugeot | 3O7 | DIESEL | Hdi | Super | 11
Peugeot | 3O7 | DIESEL | Hdi | Super | 11 |  |  |  |  |  |  | VXR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peugeot | 2O6 | PETROL | GTI | Sporty | 10
Fiat | Punto | PETROL | Sport | Tidy | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | 7
Vauxhall | Astra | PETROL | VXR | Great | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proton | Impian | PETROL | Sport | Dull | 8
Peugeot | 2O6 | PETROL | GTI | Sporty | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Renault | Megane | DIESEL | Dci | Great | 8
Honda | Civic | DIESEL | CDTi | Excellent | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rover Metro | Metro | PETROL | Club | Dull | 0
Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vauxhall | Nova | PETROL | SRI | Dull | 8
Bmw | 3 series | DIESEL | Tdi | Nice | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vauxhall | Astra | PETROL | VXR | Great | 9
Bmw | 3 series | DIESEL | [NAME] | Nice | 10