Okay, here's my issue:
My students are receiving scores every week in 5 different categories. The scores are listed as "Expanding", "Competent", "Developing, and "Beginning". I need a formula that searches for these words in specific columns and translates them into a numerical value (ie., Expanding = 4, Competent = 3, etc.)
Then, once a numerical has been ascribe, the formula needs to find the average of all these numbers. This form will be updated repeatedly throughout the school year, so it'll have to account for that.
Can I get some help?