Thank you very much kilroyscarnival ... that was a very great help you gave me! Now, through that video you shared I managed to get more familiar with the italian excel functions INDICE (INDEX) and CONFRONTA (MATCH). Using them I've got some good results but not the exact ones! As a matter of fact there is a significat error the second top mark applicant (the n. 9), see attached sample, is not shown as such! Am I perhaps uncorrectly applying those functions? If so, can I get a tip on how to correct them? Thank you for availability.

Attached Files

SAMPLE-classification-list.XLSX (11.2 KB, 6 views)