Actuarial Outpost Similar to excel rank?
 Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
 FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

US HEALTH ACTUARIAL JOBS

#1
10-04-2011, 10:25 AM
 Gareth Keenan Member CAS Join Date: Feb 2006 Location: A state that means good morning in Japanese Studying for Exam 9 Favorite beer: butter Posts: 1,094
Similar to excel rank?

Is there a function I can use to look at an array, and return the rank of the item I'm looking for. For example suppose I have

A,1
B,4
C,6
D,2

I would want to put in a third column that looked at the 1,4,6, and 2 and returns what position in the array the number was. Except in my real world situation the 1,4,6,and 2 are going to be =RAND() functions so I want to click F9, and know if each the B is lowest, C is second lowest etc, and there rank to come in the form of a number. I feel like Excel should have this function somewhere, but it's not INDEX, MATCH, or RANK(It didn't look like rank)

Suggestions?

Gareth Keenan
#2
10-04-2011, 10:28 AM
 llcooljabe Member CAS Join Date: Aug 2002 Favorite beer: Rickard's Red Posts: 14,380

ARe the letters in the first column, and the numbers in a second and the ranks in a 3rd?
__________________
www.GoodNewsNow.info
Propoganda
#3
10-04-2011, 10:33 AM
 llcooljabe Member CAS Join Date: Aug 2002 Favorite beer: Rickard's Red Posts: 14,380

I'm confused as to why you don't use RANK?
__________________
www.GoodNewsNow.info
Propoganda
#4
10-04-2011, 10:44 AM
 Gareth Keenan Member CAS Join Date: Feb 2006 Location: A state that means good morning in Japanese Studying for Exam 9 Favorite beer: butter Posts: 1,094

The reason is because I am a turd fergusson. I've tested Rank, it does what I want.

Is there a delete thread button?

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off

All times are GMT -4. The time now is 11:27 AM.

 -- Default Style - Fluid Width ---- Default Style - Fixed Width ---- Old Default Style ---- Easy on the eyes ---- Smooth Darkness ---- Chestnut ---- Apple-ish Style ---- If Apples were blue ---- If Apples were green ---- If Apples were purple ---- Halloween 2007 ---- B&W ---- Halloween ---- AO Christmas Theme ---- Turkey Day Theme ---- AO 2007 beta ---- 4th Of July Contact Us - Actuarial Outpost - Archive - Privacy Statement - Top