VBA: Get the least ten marks of each student in each group by their name

[icesanta]

Please help me.
I am looking for a VBA code to get the least ten marks of each student in each group by their name and subject.
I have uploaded an image file to understand this and there are hundreds of student names, many groups, and many subjects, and there are around 50000+ rows.

 

[icesanta]

clarification

VBA: want to know the last ten scores (sorted) of each student if cell data is present

Each student has appeared and scored in many subjects in different groups. But did not do well at all.
I want to know the last ten scores (sorted) of each student if cell data is present.
Empty cells will maks will not be considered, and there are around 50000+ rows.

 

[BSALV]

what is your excel-version ?
If 2021 or 365 you don't need VBA.
Can you add some lines with the XL2BB-tool ?

 

[Peter_SSs]

Duplicate to: VBA: Simple data arrangement issue

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.