display order of values without sorting

J

Jeff

I would like to create a sheet that can give me a weighted score at the end
of the row.

What I mean by this is I have a sheet with 4 colums and 10 rows,

each of the rows will have a weighted number in each of the colums with a
total at the end.

With out sorting the rows I would like to rank them in importance, the
highest number being a 1 the next a 2 the next highest a 3 and so on. Is
there a function that does this or does someone have a formula?

Thanks
 
S

Shaun

Try this…
This formula will create logic and will assign a value for the equivalent
word.
=IF(A1="two",2,IF(A1="three",3,IF(A1="one",1,)))
A B
1 one 1
2 one 1
3 two 2
4 three 3
5 two 2
6 three 3

This formula will allow you to sum only corresponding references.
ONE = 2 =SUMIFS(B1:B7,A1:A7,"one")
Two = 4 =SUMIFS(B1:B7,A1:A7,"two")
THREE = 6 =SUMIFS(B1:B7,A1:A7,"three")
 
N

new1

Try this…
This formula will create logic and will assign a value for the equivalent
word.
=IF(A1="two",2,IF(A1="three",3,IF(A1="one",1,)))
A       B
1       one     1
2       one     1
3       two     2
4       three   3
5       two     2
6       three   3

This formula will allow you to sum only corresponding references.
ONE = 2   =SUMIFS(B1:B7,A1:A7,"one")
Two = 4   =SUMIFS(B1:B7,A1:A7,"two")
THREE = 6   =SUMIFS(B1:B7,A1:A7,"three")

Good evening

You can also try the Excel RANK function

Regards

new1@[no/spam]realce.net
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top