Forum Discussion
Formula needed to retrieve % of correct reviews for an employee, where reviews are on separate tabs.
Hello everyone! Thank you in advance for any assistance you are able to offer. I'm working in MS 365 for web on a windows cloud environment through a Citrix network. Looking for a formula that wil...
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?
