Latest entry (date) in multiple conditions

[tchu76]

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?

Txs in advance!

Evander

----


[TABLE="width: 396"]
<tbody>[TR]
[TD]Formula:


UN [/TD]
[TD] Ref.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]030001-00001[/TD]
[TD] 39[/TD]
[TD] [/TD]
[TD] (required formula: latest date: (this example, 25/Aug)[/TD]
[/TR]
</tbody>[/TABLE]

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


[TABLE="width: 396"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Data:

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

 

[Weazel]

maybe something like...

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

in C17

[TABLE="class: grid, width: 379"]
<TBODY>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]UN. (A)</SPAN>
[/TD]
[TD]Ref. (B)</SPAN>
[/TD]
[TD]Value (C)</SPAN>
[/TD]
[TD]Date dd/mm (D)</SPAN>
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]030001-00001</SPAN>
[/TD]
[TD]39</SPAN>
[/TD]
[TD]56.238,55</SPAN>
[/TD]
[TD]27-May</SPAN>
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]030001-00001</SPAN>
[/TD]
[TD]39</SPAN>
[/TD]
[TD]56.407,22</SPAN>
[/TD]
[TD]27-May</SPAN>
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]030001-00001</SPAN>
[/TD]
[TD]39</SPAN>
[/TD]
[TD]56.617,49</SPAN>
[/TD]
[TD]30-May</SPAN>
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]030001-00001</SPAN>
[/TD]
[TD]39</SPAN>
[/TD]
[TD]56.308,24</SPAN>
[/TD]
[TD]23-Jun</SPAN>
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]030091-03091</SPAN>
[/TD]
[TD]365</SPAN>
[/TD]
[TD]7.822,31</SPAN>
[/TD]
[TD]25-Mar</SPAN>
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]030091-03091</SPAN>
[/TD]
[TD]365</SPAN>
[/TD]
[TD]7.822,31</SPAN>
[/TD]
[TD]4-Apr</SPAN>
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]030091-03091</SPAN>
[/TD]
[TD]365</SPAN>
[/TD]
[TD]7.822,31</SPAN>
[/TD]
[TD]14-May</SPAN>
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]030091-03091</SPAN>
[/TD]
[TD]365</SPAN>
[/TD]
[TD]7.822,31</SPAN>
[/TD]
[TD]30-May</SPAN>
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]030091-03091</SPAN>
[/TD]
[TD]365</SPAN>
[/TD]
[TD]7.822,31</SPAN>
[/TD]
[TD]7-Jul</SPAN>
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]030091-03091</SPAN>
[/TD]
[TD]365</SPAN>
[/TD]
[TD]7.822,31</SPAN>
[/TD]
[TD]5-Sep</SPAN>
[/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD]030091-03091</SPAN>
[/TD]
[TD]365</SPAN>
[/TD]
[TD]7.822,31</SPAN>
[/TD]
[TD]22-Sep</SPAN>
[/TD]
[/TR]
[TR]
[TD]13
[/TD]
[TD]030001-00001</SPAN>
[/TD]
[TD]39</SPAN>
[/TD]
[TD]55.408,23</SPAN>
[/TD]
[TD]25-Aug</SPAN>
[/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD]Formula:</SPAN>
[/TD]
[TD="align: left"]Ref.</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16
[/TD]
[TD]UN</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17
[/TD]
[TD]030001-00001</SPAN>
[/TD]
[TD]39</SPAN>
[/TD]
[TD="align: right"]8/25/2014 </SPAN>
[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]