Form Rank & Class Rank?

excelledsoftware · #1 09-14-2014, 09:25 PM

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)))

This basically takes the first character and then converts the 2nd character to a number then it put it in a sum + 0 to convert it all to a number that you can then use your RANK formula with.

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)

The $ sign locks that cell reference and it will not change when filling down.

Here is an attachment if the above didnt make sense.

tinfanide · #2 09-21-2014, 03:00 AM

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!

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