I work for a school system. Schools order custoidal supplies from a catalog
of 200+ items. Some items are ordered monthly, others periodically. I have
a spreadsheet of ALL the orders for each product type, it is 9000+ lines.
Prices have changed several times for many products. I want to summarize the
list of each product, identify the highest and lowest price paid and the % of
change in the price for each item.
Item Hi Low % Incr
Paper towels $4 $3 33%
5 gal Plastic bags $6 $4 50%
etc.