Forum Discussion
Formula needed to retrieve % of correct reviews for an employee, where reviews are on separate tabs.
Any ideas about what would work with multiple worksheets? I'm wondering if I can use the FILTER function somehow. It would be nice to be able to select an employee from a drop-down list, choose the start and end dates as a range, and have the results displayed for each review (worksheet) that was completed for that employee.
I've tried to figure out a way to use Pivot Tables, but I haven't been successful. There must be some way to do this, but I'm at a loss.
You wrote in the original post "See attached workbook for details on what I'm trying to do."
I don't see an attachment, however. If you are not able to attach a file, could you make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar​ - I attached the file again. Please let me know if you are not able to open it.
Sadly, the layout of the tables varies from sheet to sheet. Pass/Fail can be from column G to column N. That complicates it.
Do you want one overall percentage, or do you want a percentage for Claims, a percentage for Misc Assignments, etc?
Unfortunately, I need a percentage for each review type (tab). Yes, all the reviews contain different review items. I could perhaps mirror the results to a fixed column number and then reference that. Would that be an option?