Ranking data in arrays

[tanda]

Is it possible to rank data in an array? For example, the array is Height (a,b). I would like to create an array HeightRank (a,b) whereby all of the people in array a=1 would be ranked, etc. So, HeightRank (1,3) would be the rank of b=3 among all those with a=1. a represents a group and b a subgroup of each a. I want to rank b's within their group. I am not interested in inputing the array values in a spreadsheet and using the RANK function (I know how to do that) but need VBA code to do the same thing.

Thanks.
This message was edited by tanda on 2002-03-12 13:03
This message was edited by tanda on 2002-03-12 13:04

 

[Russell Hauf]

Thank you, Aladin, I do know that much! Sometimes I don't log in, but when I go to the message I always put in my name and pwd.