Show Max date from a table field (from another table)

[cgampon]

I have two tables. A Summary table and a detail table. I'm trying to set-up a one->many relationship

Summary Table: (table name: ProjectSummary)
holds a list of projects (project, description, start date, duration, last action, etc.)

Detail: )table name: ProjectDetail)
holds updates for items listed in the Summary table (project, date, action)

MY PROBLEM:

• I'm trying to pull the most recent date from the Detail table that corresponds to the Project name in the Summary Table.

• I used an array formula but the result is usually the first date the formula comes across. It seems that the formula is not using the entire array.

This is the formula used in the ProjectSummary[Date] column:

{=MAX(IF(ProjectDetail[Project]=[@Project],ProjectDetail[Date]))}

I thought that by using the array formula it would evaluate the entire array before returning the max date.

• Have I missed a step in the formula?

• Am i examining the right fields in order to return the MAX date?

Any assistance is greatly appreciated.

[FlameRetired]

Some context would help. If you upload a representative sample workbook ... (not pics or screenshots ... saves retyping data) I am confident someone will post a solution.

If you are not familiar with how to do this.=:

To attach a file to your post,

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.