duplicates and max date

  • Thread starter Thread starter opeyemi1
  • Start date Start date
O

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.
 
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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
Back
Top