View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Percent Function Help

No, it doesn't make sense.
Try giving us an example.
--
David Biddulph

"Pauline" wrote in message
...
I want to rank them based on col A's value counting 25% and the total value
of B, C, D's Columns counting 75%

Does this make sense?

"Gary Brown" wrote:

You said that Col A is 25% and Cols B+C+D = 75% and you want to know the
ranking % of each person.
Do you want to rank them based on their value in Col B? Col C? Col D?
Some combination of columns?
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"Pauline" wrote:

I am sorry I don't understand.

"Gary Brown" wrote:

What is the criteria for ranking?
--
Gary Brown


"Pauline" wrote:

Can someone help. I am trying to calculate the percent rank, but
here is what
I can't figure out. I have 4 columns of data A, B, C, D column A is
worth 25%
and B, C, and D totaled is worth 75% . I need to know what the
percent rank
is for this person. There is a total of 25 people.

Thanks