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