If I've got a set of numbers. For example lets say they are 12,10,8,8,6. Now if I was to rank them they would be 1st ,2nd ,3rd ,3rd ,5th respectively. Obviously there is no fourth place because there are two placed at 3rd Place. Now if my requirement is to decide which one of those should be 3rd and 4th is based on another set of numbers for example lets say the highest from 100,110,200,400,450 respectively – what would be the formula I would have to set.
2007-02-28 17:13:48 · 3 answers · asked by xix 1 in Computers & Internet ➔ Software
I want a formula ... not sort. Sorting is only for one coloumn friends .. I am talking about a dependent here. Please answer if you only know !!
2007-02-28 17:34:56 · update #1
You might use two formula's where the second list is added to the ranking, but the second list would need to be a fraction of a number.
You could use the original list in A1 through A5.
Enter the second list divided by 100 in B1 through B5:
0.100, 0.110, 0.200, 0.400, 0.450
In C1 through C5, use the formula:
=RANK(A1,A$1:A$5)+B1
And finally, in D1 through D5, rank the results of C1 through C5:
=RANK(C1,C$1:C$5,1)
2007-03-01 02:31:16 · answer #1 · answered by nospamcwt 5 · 0⤊ 0⤋
I don't think there is a formula for ordering but you can go to Tools, then Sort. It lets you choose a primary sort column, then a secondary sort column which will do what you want I think.
2007-03-01 01:21:33 · answer #2 · answered by Michael da Man 6 · 0⤊ 0⤋
you can do a sort. sort by the first column of data and then by the second and it'll rank them.
2007-03-01 01:20:19 · answer #3 · answered by eriq p 4 · 0⤊ 0⤋