Issue with a filter, merged cell
Solved
xelass
Posted messages
89
Status
Member
-
Raymond PENTIER Posted messages 58226 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58226 Registration date Status Contributor Last intervention -
Hello,
I have a problem with a filter in Excel. The table has 2 columns, on the left are the names of the students (tata, toto, titi, ...) and on the right are their grades (this is just an example).
I set up a filter so that I can select a student and see all their grades, but that's where the problem arises. The cell where the student's name appears is merged across 5 rows, and when I select the student's name, it only shows me the grade from the first line and not the others!
Is there anyone knowledgeable in Excel who could give me a solution?
Thank you in advance.
I have a problem with a filter in Excel. The table has 2 columns, on the left are the names of the students (tata, toto, titi, ...) and on the right are their grades (this is just an example).
I set up a filter so that I can select a student and see all their grades, but that's where the problem arises. The cell where the student's name appears is merged across 5 rows, and when I select the student's name, it only shows me the grade from the first line and not the others!
Is there anyone knowledgeable in Excel who could give me a solution?
Thank you in advance.
