Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MTD Rating | Excel Worksheet Functions | |||
Compute a rating of a mtd average compared to a rating scale | Excel Discussion (Misc queries) | |||
Rating | Excel Worksheet Functions | |||
RAG Rating | Charts and Charting in Excel | |||
Rating 1 to 10 | Excel Discussion (Misc queries) |