Maybe more precicely... here is my starting data:

ZONE_ID ZONE_NAME COUNT(ZN.ZCMD_ID) ACTIVE ITEM_NUMBER NAME AVG_ITEMS_PER_HOUR
1495 takj_121 9 0 22504 Ivory 0.0003125
1496 takj_125 9 0 22504 Ivory 0.0003125
1497 takj_130 9 0 22504 Ivory 0.0003125
16 Beholder 23 -1 11790 Jade Shard 0.07728
26 CSHome 1 -1 11790 Jade Shard 0
70 Cauldron 4 -1 11790 Jade Shard 0.192
48 CazicThule 53 -1 11790 Jade Shard 0.174289655172414

I then on antoher worksheet have a list
Ivory
Jade Shard

I need to find: Max AVG_ITEMS_PER_HOUR and the ZONE_NAME that that applies
to, as well as a total of AVG_ITEMS_PER_HOUR (which I can do easily enough
with a pivot table. a pivot table for "max" seems to show again to much data
so I cannot get out the data I need.