=Rank(c4,e4,g4,i4,k4) I have 5 different thing to rank but out those
I have to get one main.
Thank you so much for all your help.
2006-10-07 18:24:28 · 2 answers · asked by Michelle N 5 in Computers & Internet ➔ Software
The Rank formula in Excel works as follows:
=Rank(Number, Reference, Order)
Where Number is the Number you want to rank
Reference is the Cell range containg the number sequence
Order is Logical being 'True' for ascending order, 'False' for descending order.
So you should put your 5 values in a range sequence such as C4, D4, E4, F4, G4
Then assuming the number you want to rank is 12 then your formula should read
=Rank(12, C4:G4, TRUE)
2006-10-08 11:13:04 · answer #1 · answered by Norman 4 · 0⤊ 0⤋
a million. Abbey highway 2. Revolver 3. Sgt. Pepper 4. Rubber Soul 5. a no longer common Day's night 6. The Beatles (White Album) 7. With The Beatles 8. Magical secret excursion 9. help 10. Beatles on the marketplace 11. permit that's 12. Beatles on the marketplace
2016-12-26 12:28:51 · answer #2 · answered by santolucito 3 · 0⤊ 0⤋