Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I find best fit out of a set of options by ranking criteri

I'm trying to figure out how to rank options (or find the best fit) when a
level of importance is given on each set of data.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 256
Default How do I find best fit out of a set of options by ranking criteri

Can you provide a sample of your data, along with your expected results?

In article ,
cl_bud wrote:

I'm trying to figure out how to rank options (or find the best fit) when a
level of importance is given on each set of data.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I find best fit out of a set of options by ranking crit

For example if I have 50 different cars with criteria for Safety, gas
mileage, speed, size, etc. Each customer would categorize each of these
criteria different in importance to them. I want to see how the rank for
each car would change given their level of importance in each category. Does
this make sense?

"Domenic" wrote:

Can you provide a sample of your data, along with your expected results?

In article ,
cl_bud wrote:

I'm trying to figure out how to rank options (or find the best fit) when a
level of importance is given on each set of data.


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 762
Default How do I find best fit out of a set of options by ranking criteri

cl_bud -

This paper may help:

http://www.usfca.edu/fac-staff/middl...0304132235.pdf

- Mike
http://www.mikemiddleton.com

"cl_bud" wrote in message
...
I'm trying to figure out how to rank options (or find the best fit) when
a
level of importance is given on each set of data.



Reply
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
Find and Replace blakrapter Excel Worksheet Functions 3 December 15th 05 12:25 AM
Code needed to find records from bottom up Andy Excel Discussion (Misc queries) 4 December 5th 05 03:27 AM
find and replace, within workbook Matt Carter Excel Discussion (Misc queries) 1 November 22nd 05 12:55 AM
Edit + Find Mindy Excel Discussion (Misc queries) 2 April 8th 05 09:49 PM
find a cells from a range of cell kelvintaycc Excel Worksheet Functions 2 April 2nd 05 07:20 PM


All times are GMT +1. The time now is 05:19 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"