Finding the most recent date for multiple people

  • Thread starter Thread starter drofnats
  • Start date Start date
D

drofnats

I'm trying to find a way to get the most recent date for
each person from a list. For example:

John Smith 2/12/04
John Smith 2/29/04
Jane Doe 2/29/04
John Smith 3/11/04
Jane Doe 4/01/04

Does anyone know how I would be able to pull the 3/11/04
and 4/01/04 dates only? I can pull the max date for one,
but not for each person on my list.

Thanks,

Note: I have office 97 on my computer
 
Use a Pivot Table for that. Be somewhere in your list, go menu Data > Pivot
table. Excel should select your list and suggeet a table on a new worksheet.
OK those.

Now in this new sheet, drop your NAME tag in the ROW FIELD area and DATE tag
in the DATA area. Then doubleclick the "Amount of Date" header, choose MAX
instead of Amount. Finally format the data as dates.
 
Assuming your data is in col. A and B with headers, insert
this in C2:

=B2=MAX(IF(A2=$A$2:$A$6,$B$2:$B$6))

and press ctrl/shift/enter. Now fill the formula down.
Select columns A-C, go to Data > Filter > AutoFilter, and
filter for "TRUE" on col. C.

HTH
Jason
Atlanta, GA
 
that did the trick. thanks.
-----Original Message-----
Assuming your data is in col. A and B with headers, insert
this in C2:

=B2=MAX(IF(A2=$A$2:$A$6,$B$2:$B$6))

and press ctrl/shift/enter. Now fill the formula down.
Select columns A-C, go to Data > Filter > AutoFilter, and
filter for "TRUE" on col. C.

HTH
Jason
Atlanta, GA

.
Click to expand...
 
Back
Top