Ron as a follow-up:



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

"Ron Rosenfeld" wrote:

On Wed, 8 Dec 2004 15:23:01 -0800, "Woodkat"
wrote:

Each customer (column A) on my list has multiple dates of service(column B).
How can I sort to only show the most recent date of service?

Two methods.

1. Use a Pivot table. Drag the Customers to the ROW; drag the dates of
service to the DATA area and select MAX for the function (right click on the
Data field, select Field Settings, and then MAX).

2. a. Data/Sort: First by Column A (ascending) and then by Column B.

Then

b. Data/Subtotals: For each change in Customers, use the MAX function.

c. In the extreme left margin, you will see some very small numbers 1, 2 and
3. If you click on the 2, this should hide all except the subtotals.


--ron