Latest date - Match/lookup

[gomukuma]

Hi,
I have a colleague who is struggling with a look up, if anyone has any ideas on how to evaluate...

Data
Job No Date
51 01.09.14
40 02.08.14
35 25.06.14


Summary:
Job No Latest Date
40 formula to return the latest date (ie 01.09.14)

Any assistance would be grately appreciated.

 

[steve the fish]

Is the latest date for 40 not 02/08/2014?

If so try:

=MAX(--($A$1:$A$3=40)*$B$1:$B$3)

Enter this via CNTL-SHIFT_ENTER as it's array formula.

 

[gomukuma]

Is the latest date for 40 not 02/08/2014?

If so try:

=MAX(--($A$1:$A$3=40)*$B$1:$B$3)

Enter this via CNTL-SHIFT_ENTER as it's array formula.

Sorry, Just realised i should have had more dates for each job number..

Job No Date
40 01.09
40 02.08
40 25.06

Your formula is perfect - Thanks

 

[Aladin Akyurek]

1st Sept is more recent that 2nd August

But that date is not associated with Job No = 40...