duplicates and max date

[opeyemi1]

Hello All:

Say I have a table in excel.

The first column (column A) is made up of another column (E) and a bill
date (column F) i.e. E1&F1. The second column (column B) is made up of
column E and due date (column G) i.e. E1&G1.

Sometimes the records in column A repeat, but the entries in column B
are always different. Since these two columns have dates attached to
them. I want to set up a query that will sort column A in ascending
order then column B in ascending order. Then I want the query to give
me the last common entry in A for all my data.

E.g.
bayview03/23/2003 bayview03/27/2003
bayview03/23/2003 bayview03/28/2003
bayview03/23/2003 bayview03/30/2003
allen03/05/2003 allen03/07/2003
allen03/05/2003 allen03/09/2003
allen03/05/2003 allen03/10/2003
allen03/05/2003 allen03/11/2003
allen03/05/2003 allen03/15/2003
yonge03/02/2003 yonge03/02/2003
yonge03/02/2003 yonge03/12/2003
yonge03/02/2003 yonge03/21/2003

I want my second query to give me the following:
bayview03/23/2003 bayview03/30/2003
allen03/05/2003 allen03/15/2003
yonge03/02/2003 yonge03/21/2003

How do I set up my query to give me the latest due date (column G) that
corresponds to the records in column E.

Thanks for your kind help.

 

[Anne Troy]

In your open query, hit View-Totals. In the second column, choose from the
Group by dropdown: Last
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->