#1
|
|||
|
|||
Form Rank & Class Rank?
In the attached file, I have a score table of Form 1. There are 1A, 1B and 1C classes. I used RANK to compare the whole form scores (to get the form rank of each student). But how can I use RANK to compare the class scores (to get the class rank of each student) Please see the attached Excel file. Thank you! _rank.xlsx |
#2
|
|||
|
|||
You need to convert the Letter into a number. The CODE formula will do this.
Place this formula somewhere next to your data and fill it down (You can hide this column after) Code:
=SUM(0+LEFT(B2,1)&CODE(RIGHT(B2,1))) Let me know if you have any other questions. By the way looking at your formula before you can make it easier by typing it like so and then autofilling or copying/pasting it down Code:
=RANK(C2,C$2:C$6) Here is an attachment if the above didnt make sense. |
#3
|
|||
|
|||
Thanks for your quick reply.
But maybe I've made myself not clear. In the attached Excel file, the highlighted (orange) column will be the one I've intended to do (the result I want Excel to return). The class rank is the rank which is arranged against the class only, not the whole form. Could you have a little look at the Excel file (_rank2.xlsx) _rank2.xlsx Thank you! |
#4
|
|||
|
|||
At first I didnt quite understand but now I do. You want a rank within the class not ranking the actual class. Hmmn apart from applying a sort and then having a formula reference just those cells I am unsure how to accomplish this with formulas. a VBA script could certainly do it but I am trying to not suggest those as much as some people only want simple solutions. Anybody else have an idea of using a combination of sumif to rank each value within the class?
Otherwise I think VBA is your answer. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
designing a custom outlook form - this form is for only sending mails nt collect data | balamuralibm | Outlook | 0 | 05-21-2014 08:08 AM |
Is it possible to bind macros to keys not in the KeyCodeConstants class? | AlexR | Word VBA | 4 | 04-08-2013 10:15 AM |
Evernote--Class Notes | markg2 | Outlook | 0 | 05-10-2012 05:50 PM |
Looking for easy and quick way to draw on class notes "x-rays - image" | Lacrosseboss18 | PowerPoint | 0 | 02-04-2011 01:21 PM |
Want to search for "class", replacing with document property | YetAnotherAuthor | Word | 0 | 10-30-2009 09:43 AM |