1. On the Subtotals worksheet, sort the data by Type and further sort it by Title, both in alphabetical order.
2. Use the Subtotals feature to insert subtotal rows by Type to identify the highest Issue Price and Est. Value.
3. Collapse the data by displaying only the subtotals and grand total rows. Set a print area for the range B1:E45.
4. Use the Art worksheet to create a blank PivotTable on a new worksheet named Sold Out. Name the PivotTable Average Price by Type.
5. Use the Type and Issue Price fields, enabling Excel to determine where the fields go in the PivotTable. Add the Est. Value field to the Values area.
