what is the formula to find rank
Roll No Total Marks Rank
1 425 2
2 402
3 312
4 485 1
what is the formula to find rank
Roll No Total Marks Rank
1 425 2
2 402
3 312
4 485 1
Last edited by debdulal; 04-23-2013 at 10:33 AM.
that might be the funniest thread title I've ever seen ;-)
can you explain your question-I don't understand it?
Josie
if at first you don't succeed try doing it the way your wife told you to
Hi debdulal, Good Morning.
Your example:
Roll No|Total Marks|Rank
.....1....|......425.....|....2
.....2....|......402.....|....
.....3....|......312.....|....
.....4....|......485.....|....1
Try to do this:
.....A....|.......B......|...C...
Roll No|Total Marks|Rank
.....1....|......425.....|=RANK(B1,$B$1:$B$4,0)
.....2....|......402.....|
.....3....|......312.....|
.....4....|......485.....|
Copy down this formula till the final of range
Please, tell us if it worked for you.
I hope that can help you.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks