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

Please try in F2 and copy down:

Formula:

Please Login or Register  to view this content.

Originally Posted by HansDouwe

Please try in F2 and copy down:

Formula:

Please Login or Register  to view this content.

Thanks for the suggestion. This does not work as you have different student names. So this formula will repeat the value as well as overrides other students latest scores.
Thank you

Did you try this formula in F2 and copy down?
Everything seems to be working fine in your sample workbook.
See attachment.

Originally Posted by HansDouwe

Did you try this formula in F2 and copy down?
Everything seems to be working fine in your sample workbook.
See attachment.

Help in formula-1.JPG

Thanks for your support. I have highlighted in yellow colour where the formula is not working and what should be the correct value. This is why this formula is not working.
Many thanks
Rasike

Or, in cell G2 try:

=LET(a,FILTER(E2:E$2,(E2:E$2<>"")*(D2:D$2=D2)),INDEX(a,COUNT(a)))

Copy down.

Thank you very much for your time. This is actually working

Originally Posted by T.I.

Try this:

PHP Code: 

=LOOKUP(2,1/(($D$2:D2=D2)/($E$2:E2<>"")),$E$2:E2) 


Thank you very much for your time. This is actually working

Originally Posted by Gregb11

Or, in cell G2 try:

=LET(a,FILTER(E2:E$2,(E2:E$2<>"")*(D2:D$2=D2)),INDEX(a,COUNT(a)))

Copy down.

Thank you very much for your time. This is actually working