Hi!

I have two tables in a workbook with a logical parent-child connection. I want to display in the "parent" table for each row the highest date entered on that particular rows children.

I am using Excel 2007. I already found a way to count the number of "childrows":
=COUNTIF(Table2[ParentItem];Table1[[#This Row];[Item]])

Any ideas?