Return highest value

[CHC Consulting LLC]

Billing Tracking Tab

Column C = Milestone (Many different milestones)
Column D = Milestone Complete Date
Column G = Project Name (Many different projects)

Reports Tab

Column A = Project Name

That is what I have, this is what I need.

Column B = Highest Date from the Billing Tracking Tab, Column D
Column C = Corresponding Milestone

 

[AlphaFrog]

Billing Tracking

Excel Workbook
	C	D	G
1	Milstone	Milestone Complete Date	Projects
2	1	3/14/2011	Project1
3	2	3/15/2011	Project2
4	3	3/16/2011	Project3
5	4	3/17/2011	Project4
6	5	3/18/2011	Project4
7	6	3/19/2011	Project4
8	7	3/20/2011	Project2
9	8	3/21/2011	Project1
10	9	3/22/2011	Project1
11	10	3/23/2011	Project2
12	11	3/24/2011	Project2
13	12	3/25/2011	Project1
Sheet

Report

Excel Workbook
	A	B	C
1	Projects	Max date	Milstone
2	Project1	3/25/2011	12
3	Project2	3/24/2011	11
4	Project3	3/16/2011	3
5	Project4	3/19/2011	6
Sheet

 

[CHC Consulting LLC]

I'm on it. Thank you very much!!!