Form Rank & Class Rank?

excelledsoftware · #2 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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