Spreadsheet: 822430d1679340487-filter-function-nested-if-multi-better-simpler-expression-pivot-tbl-and-slicer-xl21-
Sheet: DATA

MAKE | MODEL | FUEL | TYPE | Desc | IG | Litre | Turbo | R/C/L | SPORTS | 3 DOOR | E/W | E/S/R | E/M | AIR CON | TRIP COMP | ALLOYS | COLOUR | YEAR | PRICE |  | DESIGN PIVOT TABLE > SLICERS:  HOW TO
Peugeot | 2O7 | PETROL | Gti | OK | 15 | 2.0 L |  | Y | Y |  |  |  |  |  |  |  | Silver | 2011 | 8000 |  | PIVOT TBL: | SELECT CELLS RANGE > INSERT > PIVOT TABLE.
Peugeot | 3O6 | DIESEL | TD | [NAME] | 13 | 1.9 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Silver |  | 600 |  | LAYOUT: | Select PIVOT TBL > DESIGN (HDR MENU)> REPORT LAYOUT > TABULAR
Honda | Civic | PETROL | Type R | [NAME] | 13 | 2.0 L |  | Y | Y |  |  |  |  |  |  |  | Silver |  | 4500 |  | SUB TOTALS: | Select PIVOT TBL > DESIGN (HDR MENU) > SUB/GRAND TOTALS > OFF / DO NOT
Fiat | Panda | PETROL | Dlux | Crap |  | 1.2 L |  | N | N |  |  |  |  |  |  |  |  |  | 300 |  | CELLS RANGE: | Select PIVOT TBL > PIVOT TBL ANALYSE (HDR MENU) > CHANGE DATA SOURCE
Citreon | Ax | PETROL | Vibe | Crap |  | 1.1 L |  | N | N |  |  |  |  |  |  |  |  |  | 150 |  | ADD FIELDS: | R/C PIVOT TBL, SHOW FIELD LIST, TICK, ROWS
Vauxhall | Nova | PETROL | SRI | Dull | 8 | 1.4 L |  | Y | N |  |  |  |  |  |  |  | Silver |  | 250 |  | DEFAULT: | FILE, MORE, OPTIONS, DATA, EDIT DEFAULT LAYOUT, REPORT, TABULAR
Rover Metro | Metro | PETROL | Club | Dull |  | 1.1 L |  | Y | N |  |  |  |  |  |  |  |  |  | 100 |  | DELETED ROWS: | SELECT DATA, DELETE, TBL ROW.  PIVOT TABLE, R/C, REFRESH
Peugeot | 3O7 | DIESEL | Hdi | [NAME] | 11 | 2.0 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Silver |  | 900 |  | DESIGN TABLE > SLICERS:  HOW TO
Peugeot | 2O6 | DIESEL | GT Hdi | [NAME] | 7 | 2.0 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Silver | 2004 | 1750 |  | TABLE ON: | SELECT DATA > INSERT > TABLE
Bmw | 3 series | DIESEL | Tdi | Nice | 10 | 2.0 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Black |  | 1300 |  | SLICERS: | SELECT DATA > INSERT > SLICER > TICK
Bmw | Z4 | PETROL | Sport | Great | 15 | 2.5 L |  | Y | Y | Y | Y |  | Y | Y | Y | Y | Blue |  | 3500 |  | TABLE OFF: | SELECT TABLE HDR, R/C, TABLE, CONVERT RANGE
Bmw | X4 | PETROL | 4WD | 4x4 | 16 | 3.0 L |  | Y | Y |  | Y | Y | Y | Y | Y | Y | Silver |  | 5500
Renault | Megane | DIESEL | Dci | Great | 8 | 1.9 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Blue |  | 900
Proton | Impian | PETROL | Sport | Dull | 8 | 1.6 L | Y | Y |  |  | Y |  | Y |  |  | Y | White |  | 400
Ford | Focus | DIESEL | TDCi | Great | 11 | 1.8 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Grey |  | 3400
Honda | Civic | DIESEL | CDTi | Great | 10 | 1.7 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Silver |  | 3800
Peugeot | 3O7 | DIESEL | Hdi | Super | 11 | 2.0 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Blue | 2003 | 2400
Fiat | Punto | PETROL | Sport | Tidy | 8 | 1.6 L |  | Y | Y | Y | Y |  | Y |  |  | Y | Green |  | 800
Vauxhall | Astra | PETROL | VXR | Great | 9 | 2.0 L |  | Y | Y | Y | Y | Y | Y | Y | Y | Y | Red |  | 7000
Peugeot | 2O6 | PETROL | GTI | Sporty | 10 | 2.0 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Blue |  | 700
Honda | Civic | DIESEL | CDTi | Great | 10 | 2.2 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Silver | 2003 | 2200
Peugeot | 2O6 | DIESEL | Hdi | [NAME] | 7 | 2.0 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Silver |  | 1500
Bmw | 3 series | DIESEL | Tdi | Nice | 10 | 2.0 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Black |  | 1800
Bmw | 3 series | DIESEL | [NAME] | Nice | 10 | 2.0 L | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Black |  | 2200