How can I find last row and score which meets criteria?

s/s has 325501 rows.

Column C contains names of people (whether present or not -I enclose small attachment to illustrate).
Column J contains scores (when present).

I need column K to list last row where column C name scored and column L to list last score.

I think I need macros which I can fill down both columns (??).
I would be most grateful for any help.
Big thanks.
Colwyn.

colwyn,

I'm not sure why/if you need the last scoring row -- you can retrieve the last score without it using:

Please Login or Register  to view this content.

Does that resolve your issue ?