Return last value in a list based on a given condition (Month)

[steveh1873]

Date	Month	Total
19/07/2015 <tbody> </tbody>	July <tbody> </tbody>	392 <tbody> </tbody>
26/07/2015 <tbody> </tbody>	July <tbody> </tbody>	409 <tbody> </tbody>
02/08/2015 <tbody> </tbody>	August <tbody> </tbody>	416 <tbody> </tbody>
09/08/2015 <tbody> </tbody>	August <tbody> </tbody>	383 <tbody> </tbody>
16/08/2015 <tbody> </tbody>	August <tbody> </tbody>	363 <tbody> </tbody>
23/08/2015 <tbody> </tbody>	August <tbody> </tbody>	290 <tbody> </tbody>
30/08/2015 <tbody> </tbody>	August <tbody> </tbody>	351 <tbody> </tbody>
06/09/2015 <tbody> </tbody>	September <tbody> </tbody>	362 <tbody> </tbody>
13/09/2015 <tbody> </tbody>	September <tbody> </tbody>	354 <tbody> </tbody>

<tbody>
</tbody>

Hi there,

Using the above table, what formula can I use to return the last value in the total column, that is the latest figure for the month, please?

i.e. for July it should be - 409, August - 351 and September - 354.

If i create a table listing all the months, i'd like to know the last value (chronologically) for each month.

Thanks in advance.

Steve

 

[Special-K99]

=INDEX(C$1:C$9,MATCH(MAX(IF(B$1:B$9=E1,A1:A9)),A$1:A$9,0),1)
Array formula, use Ctrl-Shift-Enter

This assumes the dates will not be duplicated

 

[BarryL]

Try the below. It's not an array so just enter is fine

=LOOKUP(2,1/(B:B=K1),C:C)

where B:B is the second column above. K1 is the start of your list of months and C:C contains the values.