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

----

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>

 

[Weazel]

maybe something like...

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

in C17

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

<TBODY>
</TBODY>