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