How do I find the last row which meets criteria??

[colwyn]

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 (if present).

I need column N to list the last row number where each column C name scored points (not just when he\she was last present).

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

[DonkeyOte]

Colwyn, why have you marked the below Q Solved if not so ?

http://www.excelforum.com/excel-work...-criteria.html

Please do not duplicate posts.

You can adapt the solution provided for returning score by returning the ROW of the range as opposed to the score in the final parameter of the LOOKUP.

[colwyn]

DonkeyOte - thanks again.
It isn't a duplicate as I'm trying to achieve a different output related to my first post.
Can you please help me? I've done as you suggest and put ROW where ISNUMBER was in your code but it isn't doing what is needed.
Big thanks.
Colwyn.

Later: Have now done this and thank you for your help. I put the ROW before the final range and it worked just fine.