A slight variation of Rons and Elkars suggestions to get the row number

=MATCH(MAX(IF(A1:A5=C1,B1:B5)),(A1:A5=C1)*(B1:B5), 0)

array entered. Just in case some of the numbers are duplicated among
different people.



" wrote:

Super Thanks Ron - the first formula does exactly what I was looking
for ;-)

Regards,
Martin