Ranking Words

  • Thread starter Thread starter MacScott
  • Start date Start date
M

MacScott

Is there a function that will let me calculate the rank of a word durin
data entry the same way the function rank(#) works on numbers?

Name Rank
Zander 5
Allen 1
Mark 2
Mike 3
Mikey 4
 
why won't a simple sort work. It could be done automatically, if desired,
with each entry...
 
Don said:
*why won't a simple sort work. It could be done automatically, i
desired,
with each entry...
Click to expand...
*[/QUOTE]

I need the ranking data in a field for a lookup point later in th
spreadsheet..
 
More explanation would help us help you. You could use the match function to
find a word.
If you want to RANK then sort and number the adjacent column.

--
Don Guillett
SalesAid Software
(e-mail address removed)
MacScott > said:
*
Click to expand...

I need the ranking data in a field for a lookup point later in the
spreadsheet...
[/QUOTE]
 
I am trying to make a Track and Field totals sheet. The coaches for
the various schools come in and put in the athlete's name, school
event, and qualifying time before the meet. That gives me 173 names i
a list with the headers:

event - Name - School - QTime

From here I rank everyone in each event based on their time. From thi
ranking, I want to autopopulate spreadsheets where I laid out th
events. I know that I want to have 100MeterRank1 in the best lane an
that is easy to find (formula combines event with rank and fetches nam
and school). I am using the index( Match()) functions to go thru a
setup everyone and its working fine.

Now I am working on events that do not have times so I have to find
way to rank the name, event, and school information so that I can ge
the unknown number of people in the Discus to the right sheet.

I am using Index() over the vlookup as the name entry sheet could b
sorted in all kinds of directions but I want to keep the data correct.

SO, I can not count on the names, schools, or events being in any orde
or grouped together. THUS, if I could come up with something tha
could look at a word (School + Name) and give that some kind o
numerical value, I can extract that data the way I did the time
events... using index() to find DiscusRank4 and put the name and schoo
in the proper area.

I am hoping to use this for future events and wanted to get th
formulas to do as much work for me as I can...

:
 
Back
Top