Find the last populated cell in a date range

[raccoon588]

In column A i have a whole year of dates. In column L i have number. How do i look for the last number entered in column L per each month. so in one cell i would put January and (38) should show and for December (17484) should show.

 

[nemmi69]

For the last used cell in column B

Dim lRow As Long

Sub LastRow()
lRow = Cells(Rows.Count, 2).End(xlUp).Row
MsgBox "Last row " & lRow
End Sub

 

[ajetrumpet]

you might be able to manipulate this function in excel by putting the "date" value in the section where they are putting the "temperature reading" in for criteria. Also, I'm not sure about this but you might look into the MATCH function and VLOOKUP function. They might be relevant, but I'm not sure. Those are just what come to mind, based on your image.

 

[Fluff]

How about

Book1
	A	B										L	M	N	O
1
2	18/12/2019
3	19/12/2019
4	20/12/2019											38		December	25
5	21/12/2019													January	3
6	22/12/2019
7	23/12/2019
8	24/12/2019											22
9	25/12/2019											11
10	26/12/2019											25
11	27/12/2019
12	28/12/2019
13	29/12/2019
14	30/12/2019
15	31/12/2019
16	01/01/2020											1
17	02/01/2020											2
18	03/01/2020											3
19	04/01/2020
20	05/01/2020
Sheet2

Cell Formulas
Range	Formula
O4:O5	O4	=LOOKUP(2,1/((MONTH($A$2:$A$20)=MONTH(N4&1))*($L$2:$L$20<>"")),$L$2:$L$20)