Ranking multiple columns

[mrcsbenson]

I am trying to come up with a ranking system that would take into account two separate values (from 2 different columns) and come up with a combined score (or rank).

In an ideal world, the formula would look at column(s) 'B' & 'C' and return a score that would rank these accounts from 1- whatever

Even better would be a way to rank column B holding 75% and column C weighting at 25% to make a total of 100% total ranking score.

 

[MountainFog]

 

[mrcsbenson]

Thank you

View attachment 111139

View attachment 111140

Thank you

 

[mrcsbenson]

View attachment 111139

View attachment 111140

Now if I changed the numbers around, will ranking automatically change or how could I do this?

 

[MountainFog]

Yes it should. What numbers would you be changing?

 

[mrcsbenson]

Yes it should. What numbers would you be changing?

The pricing numbers (Column B) would change.

 

[MountainFog]

yes

 

[mrcsbenson]

yes

Okay thank you

 

[MountainFog]

I saw your post on the other one, what is wrong with the solution?

 

[mrcsbenson]

Hi -

the ranking isn't working. It looks a little out of whack