How to fill a value from following rows

[Polite123]

Hi Everyone,

I need some help in my data for filling 0 values with the closest value available.

Input data:

Months	Values
Jan	0
Feb	0
Mar	501
Apr	200
May	36
Jun	81
July	0
Aug	0
Sep	0
Oct	23
Nov	12
Dec	1

Output data:

Only future values are to be considered.

Months	Values
Jan	501
Feb	501
Mar	501
Apr	200
May	36
Jun	81
July	23
Aug	23
Sep	23
Oct	23
Nov	12
Dec	1

Any help would be appreciated.Thanks in advance:)

[Ladarthure · Accepted solution]

Hi @Polite123,

I used one simple solution which is to sort at the beginning from december to jannuary, and then use a multi-row formula to duplicate the value, if you had precise dates, it could be even easier.

Tell me if it works for you!

[Polite123]

Thanks a lot ..It works:)