LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MTD Rating reddy Excel Worksheet Functions 2 January 12th 09 10:40 PM
Compute a rating of a mtd average compared to a rating scale reddy Excel Discussion (Misc queries) 0 January 12th 09 06:33 PM
Rating Arne Hegefors Excel Worksheet Functions 5 March 19th 07 05:25 PM
RAG Rating Andy Brander Charts and Charting in Excel 1 April 27th 05 02:25 PM
Rating 1 to 10 Kevin Lin Excel Discussion (Misc queries) 5 March 2nd 05 02:09 PM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"