searching for repeating text
Howdy~
I am using excel to complete weekly employee reviews. The employee rating
is done on a point scale. E.g., outstanding= 10, good = 8....etc
In the reveiw an employee gets a rating from the total point unless they
score needs improvment in two or a unsatisfactory in a single feild.
Is there a way to scan short list of text and give a points total unless the
above paragraph is met.
For example, the rating could have 4 fields and two employee scores
Outstanding = 10
Outstanding = 10
Outstanding = 10
Outstanding = 10
or a total of 40 points = outstanding
but a different employee could score
Outstanding = 10
Outstanding = 10
Outstanding = 10
Unsatisfactory= 4
How can I scan to find that single "U" to give a rating of Unsatisfactory?
I cannot use points becuase this empoyees high marks in the frist three
categories would skew the numbers
|