View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nadine nadine is offline
external usenet poster
 
Posts: 216
Default Formula for rating results

Look for a help creating a formula, if it possible, to find out the overall
rating results
example - first row going across lists all the options provided - there are
20 options and people rated the options in order of preference
first column going down lists the poeples names
for each name - going across have entered the rating given for an option 1
thru 20.

Is there a way to find out the overall rating of an option.

What I want to do in the end is build a list of the options and list them in
the order of the preference, based on the ratings.
i.e. if the 3rd option was the first choice by everyone then would put it
first on the new list.

Thanks for any help
Nadine