Maximum date from a Criteria

[Pasadu]

Dear Sir,
Please I have a data where I want to select the maximum date that a container was dropped on the same consignment. This means the consignment has many containers but were dropped on separate dates. I want the maximum or the last date that the container of each consignment was dropped. Thank You.

 

[bosco_yip]

In I4 formula copied down :

=MAXIFS(H:H,F:F,F4)

or,

=AGGREGATE(14,6,(H$1:H$100)/(F$1:F$100=F4),1)

 

[pecoflyer]

Avoid using merged ells, they are nothing but trouble !
Try the formatting " Center across selection" instead

Using Merged Cells Effectively in Excel - Excel Solutions

There's one simple piece of advice for using merged cells effectively in Excel...

excel.solutions