Thread: Max value from column subset?

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?

Originally Posted by Carolina

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?

It's quite tricky to make out exactly what you're after, however if I'm reading this right you're looking for something along the lines of:

=VLOOKUP(parenttable,MAX(rowofchilddata),columntoreturn,FALSE)

...where:
parenttable = data in the parent table
rowofchilddata = the row that you're looking for the max value in
columntoreturn = the number of the column in the parenttable you wish to return as the result