Creating priority ranking based on multiple criteria

[Justin Beeler]

I am trying to automate the ranking of 23 options (rows) based on 5 different input fields (columns). Is there a basic formula to say "consider these 5 columns, in the first column the lowest values are preferred, 2nd the highest is preferred, etc", and then give an overall ranking for the 23 options? If not a formula, what might be an efficient workflow to generate this result?

 

[SirJB7]

Hi, Justin Beeler!
Briefly: no, there isn't, unless you can build a formula with a numeric result into a helper column and then use SMALL or LARGE functions depending on how you constructed it.
Regards!
PS: Even you've introduced yourself, if you didn't it yet, as a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

 

[oldchippy]

I thought for a minute Justin Bieber had joined the forum

Welcome Justin

 

[NARAYANK991]

Hi Justin ,

See if the uploaded file helps.

The ordering cells have 1 for ascending order , in which a score of 1 is highest and a score of 23 is the lowest , and -1 for descending order , where a score of 23 is the highest and a score of 1 is the lowest.

The weightage cells can be used to decide which score should have a greater weightage in the overall score.

Narayan

 

[Justin Beeler]

Thanks Narayank991! I appreciate you taking time to help me out. Your code doesn't do exactly what I am looking for, but gave me some good ideas.