Forum Discussion
Johnny_B1640
Dec 24, 2023Copper Contributor
Is there a formula that lists the agents with an average of 100%
I have data that has all of the grades of my team. Members will have multiple entries in excel as we're graded per transaction. I just need a formula that lists all members that have an average score of 100% or more
- Johnny_B1640Copper ContributorYou're a lifesaver! This worked perfectly. One more question tho: I'm planning to make a simple dashboard for simple presentation that doesn't require much tinkering other than adding more raw data. That said, is there a way for the formula to ignore the blank cells? I tried using whole columns instead of just specific ranges that contain data and it's just returning 0.
If the range with non-empty cells is contiguous, you can define dynamic named ranges and use those in the formula. Or convert the range to a table; add new data to the table and refer to the table columns in the formula.
I have attached a demo workbook with both approaches.