Forum Discussion
Return multiple values across multiple sheets
Power Query variant is in attached file
It all depends on your business process. If you or someone else update results in the same file it could be done in separate sheets. If you copy/paste from another file it's more reasonable to use these other files as the source. It's also better from technology point of view.
- Thanks Sergei,
What you have created works perfectly although I am at a bit of a loss as to how to translate what you have done to my whole spreadsheet. Is there somewhere with the steps so I can see how to apply it to my whole set of data and expand what you have done for a whole school of student names and multiple sheets of data?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 stepsHow to use: In Param sheet update the Path to Excel file with Subtest sheets with yours then Refresh the query
