On Thu, 9 Dec 2004 14:09:02 -0800, "Woodkat"
wrote:

I have never used a pivot table so I am trying suggestion #2 first:

I am able to do the data sort, but am not sure how to do the “For each
change in Customers, use the MAX function". How would I dinstinguish the
change in customer? Could you give me an example formula? Thanks


"Data/Subtotals" as I wrote in my previous post is a shortcut notation. It
means to select the Data menu from the top line in Excel; and then select
Subtotals from the List that drops down (just as you did in order to get to the
Sort option).

Once you do that, a dialog box will open with the options I mentioned.


--ron