| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percent Function Help
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percent Function Help
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percent Function Help
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percent Function Help
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percent Function Help
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Percent | New Users to Excel | |||
| Percent | New Users to Excel | |||
| Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
| is there a percent error function in excel? | Excel Worksheet Functions | |||
| Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
Hybrid Mode
