Posted by Brett on December 11, 2001 7:46 AM
Survey data for resturants is entered in rows:
Restaurant, Surveyor, Rating out of 5
Sunshine Cafe, J.Smith, 4
A list of Restaurants running down G are used to provide validated entries.
The list of surveyors running down J is used to validate entries.
The following formulae are used:
In L, the number of surveys:
average score (ignore zeroes):
What I would like is a formula to calculate the number of different surveyors for each restuarant, to check if the same person is going back and givving it a high score.