Spreadsheet: 887600d1737844186-create-a-unique-list-of-years-in-descending-order-based-on-a-comparison-port-test-file-excel-2016-version
Sheet: Summary - Port

 |  |  |  |  |  |  | Vintage Year Bottle Count for Port
Port | [NAME]. in Total |  |  |  |  |  | 2037 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | These are TOTALS, it is not filtered data, it is all Port related data |  |  |  |  |  |  |  | These are TOTALS, it is not filtered data, it is all Port related data |  |  |  |  |  |  |  |  |  |  | These are TOTALS, it is not filtered data, it is all Port related data |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cells BG4 to BG11 are the correct answers and should appear in cells BH4 to BH11 as formulas
375 ml |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO NOT erase the "Yes" in cell V3 --> | Yes | Port Producer (DO NOT erase the Yes in cell V3) | 375 ml | 500 ml | 700 ml | 750 ml | Magnum | Total Bottles of Port |  | Port Producer | VP | SQVP | LBV | 10 y.o. Tawny | 10 y.o. White | 20 y.o. Tawny | 20 y.o. White | 30 y.o. Tawny | 30 y.o. White | 40 y.o. Tawny | 40 y.o. White | 50 y.o. Tawny | 50 y.o. White | 60 y.o. Tawny | 60 y.o. White | 70 y.o. Tawny | 70 y.o. White | Colheita | Crusted | Ruby Reserve | White Colheita | White Port | More than 40 Tawny | More than 40 White | Bonificador | Total Bottles of Port |  |  | [NAME] | VP | SQVP | LBV | 10 y.o. Tawny | 10 y.o. White | 20 y.o. Tawny | 20 y.o. White | 30 y.o. Tawny | 30 y.o. White | 40 y.o. Tawny | 40 y.o. White | 50 y.o. Tawny | 50 y.o. White | 60 y.o. Tawny | 60 y.o. White | 70 y.o. Tawny | 70 y.o. White | Colheita | Crusted | Ruby Reserve | White Colheita | White Port | More than 40 Tawny | More than 40 White | Bonificador
500 ml |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1997
700 ml |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1996
750 ml |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994
Magnum |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1985
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | --
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | --
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | --
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | --
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total of ALL Vintages
 |  |  |  |  |  |  | DO NOT
 |  |  |  |  |  |  | ERASE