get the value of the last day of the month

Navigation
0

I have a very long table of dates and values in excel 

A         B
-------   -------
1/1/17    10
3/1/17    7
31/1/17   6
6/2/17    6
15/2/17   6
23/2/17   98
3/3/17    25
13/3/17   5
31/3/17   18

I need to find the values in column B for the last values of the month. according to the example for January it would be 6, for February 98 and for March 18. I wish to do it by means of formulas and not with VBA.

thanks in advance ...

    
asked by Eric Capnu 23.11.2017 в 16:24
source

1 answer

0

This is what I can think of without having more information that you need:

Let me know if it works or if I can help / modify my answer

    
answered by 12.12.2017 в 05:09
Problem with Turbolink in ruby on rails Page loses styles by adding "1" in PHP