Pulling data from a sheet
I have a report that I do monthly that records the data from the following sheet. At the end of the month I usually filter columns and manually count errors for each responsible party and move them to a another sheet that records each persons errors for the whole year. I record data for about 30 individuals so the sheet below and get full. I am trying to cut down on time if possible that I do my monthly reports.
What I want to know is there any way to pull data from this sheet ^ using some type of formula or indexing without filtering and manually counting each month. On another report I use, I use the formula COLLECT to pull how many jobs, hours, and whether each designer stays within budget from a sheet of 200 rows but it paste the info in a single cell. I am looking to extract data from the sheet listed above but in this form: Responsible Party, Error Category, Brief description on another sheet. I hope this makes sense, but please let me know if you have any questions.
Help Article Resources
Check out the Formula Handbook template!