Spreadsheet: 719578d1613729323-creating-a-top-5-list-with-conditionals-orderlist_top5-example
Sheet: Orders

so-id | Responsible | Make | Model | Mileage | Transmission | Stereo | Navigation | Price | Warranty | Sold?
170001 | [NAME] | Ford | Courier | 12541 | Manual | Basic | No | 2900 | Yes | Yes
170002 | [NAME] | Honda | CR-V | 37652 | Automatic | Basic | Yes | 3500 | No | No
170003 | Stevie | Mercedes Benz | Vito | 101521 | Automatic | Medium | No | 3100 | Yes | No
170004 | [NAME] | Ford | Courier | 29775 | Manual | Basic | No | 1950 | Yes | Yes
170005 | [NAME] | BMW | 760Li | 45292 | Automatic | Premium | Yes | 56960 | No | No
170006 | Stevie | Citroen | 2CV | 347144 | Manual | None | No | 350 | No | Yes
170007 | [NAME] | Honda | Jazz | 98658 | Manual | Medium | No | 1200 | No | Yes
170008 | [NAME] | Toyota | Camry | 70633 | Automatic | Medium | Yes | 1600 | Yes | No
170009 | Stevie | Nissan | 200SX | 55229 | Manual | Basic | No | 1900 | No | No
170010 | [NAME] | Ford | Courier | 28340 | Manual | Basic | No | 1550 | Yes | No
170011 | [NAME] | BMW | 330d | 30927 | Automatic | Large | Yes | 6780 | Yes | Yes
170012 | Stevie | Mercedes Benz | Vito | 85264 | Automatic | Medium | Yes | 4896 | No | No
170013 | [NAME] | Toyota | Corolla | 64731 | Manual | Basic | No | 3120 | No | Yes
170014 | [NAME] | Toyota | [NAME] | 206972 | Manual | Medium | Yes | 21650 | Yes | No
170015 | Stevie | Lada | Niva | 459234 | Manual | Basic | No | 965 | No | No
170016 | [NAME] | BMW | 320i | 64287 | Automatic | Premium | Yes | 8526 | No | No
170017 | [NAME] | Toyota | Corolla | 60200 | Manual | Medium | No | 2100 | Yes | No
170018 | Stevie | Mercedes Benz | E220CDI | 684962 | Automatic | Medium | Yes | 3540 | No | No
170019 | [NAME] | Opel | Insignia | 124855 | Automatic | Medium | Yes | 3219 | Yes | Yes
170020 | [NAME] | Volvo | XC70 | 274161 | Automatic | Medium | No | 2546 | No | No
170021 | Stevie | Ford | Capri | 197346 | Manual | Basic | No | 1240 | No | No
170022 | [NAME] | Volvo | Amazon | 206580 | Manual | None | No | 1160 | No | Yes
170023 | [NAME] | Mercedes Benz | S500 | 144526 | Automatic | Premium | Yes | 9543 | No | No
170024 | Stevie | Opel | [NAME] | 16769 | Automatic | Large | Yes | 5542 | Yes | No
170025 | [NAME] | KIA | Soul | 19885 | Automatic | Medium | No | 4597 | Yes | No
170026 | [NAME] | KIA | Stinger | 13462 | Automatic | Large | Yes | 6580 | Yes | No
170027 | Stevie | BMW | i3 | 23447 | Automatic | Medium | Yes | 7059 | Yes | Yes
170028 | [NAME] | Jaguar | S-Type | 95276 | Automatic | Large | Yes | 1246 | No | No
170029 | [NAME] | Ford | GT40 | 9514 | Manual | None | No | 97643 | No | No
170030 | [NAME] | Opel | [NAME] | 54200 | Manual | Basic | Yes | 1950 | Yes | Yes
Get "so-id" from top 5 highest price (column I) where: Column F = Manual Column J = Yes |  |  |  |  |  | Get "so-id" from top 5 highest price (column I) where: Column B = [NAME] = Yes |  |  |  |  |  | Get "so-id" from top 10 highest mileage (column E) where: Column K = No
Example 1 for top 5 |  |  |  |  |  | Example 2 for top 5 |  |  |  |  |  | Example 3 for top 10
Top 5 expensive cars |  |  |  |  |  | Top 5 expensive cars sold by [NAME] |  |  |  |  |  | Top 10 mileage for cars not sold
With manual transmission and warranty |  |  |  |  |  | With basic stereo
so-id | Responsible | Make | Model | Price |  | so-id | Responsible | Make | Model | Price |  | so-id | Responsible | Make | Model | Mileage
170014 |  |  |  |  |  | 170013 |  |  |  |  |  | 170018
170001 |  |  |  |  |  | 170001 |  |  |  |  |  | 170015
170017 |  |  |  |  |  | 170030 |  |  |  |  |  | 170020
170004 |  |  |  |  |  | 170004 |  |  |  |  |  | 170014
170010 |  |  |  |  |  |  |  |  |  |  |  | 170021
 |  |  |  |  |  |  |  |  |  |  |  | 170023
 |  |  |  |  |  |  |  |  |  |  |  | 170003
 |  |  |  |  |  |  |  |  |  |  |  | 170028
 |  |  |  |  |  |  |  |  |  |  |  | 170012
 |  |  |  |  |  |  |  |  |  |  |  | 170008