Index Match Max Date Formula

Design Department

I have one table for shipping :

And another table for Project Closeout:

I would like to write a formula to auto-populate the max ship date for each project.

Leibel S

See below. Change the column names to match your ranges.=

=MAX(COLLECT([Ship Date]:[Ship Date], [Project]:[Project], Project@row))

Design Department

Can you add the table names to your formula?:

Shipping table

Project Closeout table

Thanks much!

Leibel S

You would need to create your own cross sheet references...