SOLVED:Need help to find a formula to repeat a previous value until there there is new value

New Contributor

I am finding very challenging on getting a correct formula on below.

Can you please help me in creating a formula to repeat the science score for each student name until there is a new science score.
I have attached the the example file and highly appreciate if someone can give me some insights on defining the correct formula.Help in formula.JPG 

2 Replies
best response confirmed by rasikedesilva (New Contributor)

@rasikedesilva Try below formula-


For dynamic spill array try below formula. See the attached file.




Thank you so much. This is working wine  @Harun24HR