Forum Discussion
Return multiple values across multiple sheets
I have multiple sheets in a workbook for teachers to record marks in tests students take. Students will progress through these tests at different rates and I want a summary of what test students are ...
Power Query variant attached. You should explain the logic to apply for cases like Carly Simon:
+ In the event where a Student has the same Result & Date in the same or in different Subset sheets, which record(s) should be reported
Same comments as Sergei re. Subset sheets consistency, names...
+ Data quality issues: some cells that are supposed to be empty actually contain space(s) ==> Unecessary query steps
How to use: In Param sheet update the Path to Excel file with Subtest sheets with yours then Refresh the query
Thank you so much for your assistance, the record that i want reported is the highest subtest level i.e. The highest number subtest for Carly Simon would be Subtest 5, the date achieved and the result. I can see in my dummy data that she achieved a result in 3 after 5- my error with the dummy data.