# Latest entry (date) in multiple conditions

#### tchu76

##### New Member
Hello, guys,

Little help, please: I'm trying to figure out a formula so the data below (4 columns, several records) reveals the latest date given a "UN" and "Ref." fields:

Any guess?

Evander

----

 Formula: UN Ref. 030001-00001 39 (required formula: latest date: (this example, 25/Aug)

<tbody>
</tbody>

----------------

 Data: UN. (A) Ref. (B) Value (C) Date dd/mm (D) 030001-00001 39 56.238,55 27/05 030001-00001 39 56.407,22 27/05 030001-00001 39 56.617,49 30/05 030001-00001 39 56.308,24 23/06 030091-03091 365 7.822,31 25/03 030091-03091 365 7.822,31 04/04 030091-03091 365 7.822,31 14/05 030091-03091 365 7.822,31 30/05 030091-03091 365 7.822,31 07/07 030091-03091 365 7.822,31 05/09 030091-03091 365 7.822,31 22/09 030001-00001 39 55.408,23 25/08

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
maybe something like...

=MAX(INDEX((A2:A13=A17)*(B2:B13=B17)*D2:D13,0))

in C17

 A B C D 1 UN. (A) Ref. (B) Value (C) Date dd/mm (D) 2 030001-00001 39 56.238,55 27-May 3 030001-00001 39 56.407,22 27-May 4 030001-00001 39 56.617,49 30-May 5 030001-00001 39 56.308,24 23-Jun 6 030091-03091 365 7.822,31 25-Mar 7 030091-03091 365 7.822,31 4-Apr 8 030091-03091 365 7.822,31 14-May 9 030091-03091 365 7.822,31 30-May 10 030091-03091 365 7.822,31 7-Jul 11 030091-03091 365 7.822,31 5-Sep 12 030091-03091 365 7.822,31 22-Sep 13 030001-00001 39 55.408,23 25-Aug 14 15 Formula: Ref. 16 UN 17 030001-00001 39 8/25/2014

<TBODY>
</TBODY>

Replies
10
Views
405
Replies
8
Views
637
Replies
12
Views
507
Replies
1
Views
431
Replies
11
Views
973

1,220,954
Messages
6,157,043
Members
451,394
Latest member
indrajeet_rajput

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back