Is there a FORMULA for this issue? THANK YOU IN ADVANCE

Closed
Sha - Jan 13, 2015 at 08:53 AM
 RayH - Jan 14, 2015 at 05:44 PM
Hello,

Please help, the issue goes like this,

I want to find a NAME within a RANGE of CELLS and the result would be the LATEST DATE they have in the list with the status either DELIVERED or RECEIVED.

for example:

DATE - NAME - STATUS (DELIVERED/RECEIVED)

1/05/2015 - CCC - RECEIVED
1/08/2015 - AAA - DELIVERED
1/09/2015 - AAA - RECEIVED
1/09/2015 - BBB - DELIVERED
1/10/2015 - CCC - DELIVERED
1/11/2015 - AAA - DELIVERED
1/13/2015 - AAA - RECEIVED

so the results should be:

AAA - LAST DELIVERED - 1/11/2015
AAA - LAST RECEIVED - 1/13/2015


1 reply

Would a pivot table solution work for you?

Like this?

Max of DATE Column Labels
Row Labels DELIVERED RECEIVED
AAA 1/11/2015 1/13/2015
BBB 1/9/2015
CCC 1/10/2015 1/5/2015
0