score

Hello- I want to Auto Rank a list by a Total Score column. The current table was generated using formulas from another sheet that can allow additional rows. I also want to make sure any new or deleted records get reflected in this final table. Thank you <colgroup><col...

Hi all this is my first post and hope someone can help. I’m trying to automate scrabble scores in a simple table. In row 1 I have the players names utilising 2 columns each. Column 1 has the score for each turn column 2 has a running total for each player. the formula for each column is...

Hi, I'm fairly new to writing code and trying to write a macro that will sort my pivot table by either a month, or by a subtotal for a group. The months are just grouping for days and these months also fall into another grouping done by adding another row field not grouping in the pivot table...

Hi All, I've developed a spreadsheet which is an audit document however some sections are not applicable to some sites. My issue is that because the questions are not applicable, I don't assign a score which results in a percentage score of 0%. This has a negative impact on their overall score...

Hi there, i know this has been discussed but i cant seem to find my solution. Cell E428 is and excel formula. I would like to run another macro each time the value changes to 0. Below is what i did but, somehow, the macro doesnt run. able to share what went wrong? thank you in advance...

Hi I need help on how to extract unique name from the excel cell and then sum up the total score for each name. I have excel sheet where the name for all participates has entered in one cell as example below Name Score ABC;#DEF;#HIJ;# 5 ABC;#XYZ;#HIJ;# 2 MNO;#DEF;#HIJ;# 3...

I am not sure if this would be a place to seek assistance but I thought I would try. I am assisting a team to calculate their productivity percentage (score tied to bonus). Its a little complicated then just regular productivity. The team has 10 days to complete a task. I would like to...

I have a list of names in Column 1 down to 1056 rows but that size will vary. There are no spaces between the names. The number in column 2 corresponds to the score for those names. In most cases the names are repeated 10 times with different scores. Sometimes there will not be 10 names and 10...

Hi all, I want excel to return me the value of 1, when the percentage score is higher than 90%, value of 2, when the the percentage score is between 80% and 90%, and so on. Would appreciate your help. <tbody> </tbody> <tbody> 90% 1 80% 2 70% 3 60% 4 50% 5 40% 6 30% 7 20% 8...

I have scores for 4 different people in range C4:Q37,Z4:AL37,AW4:BK37 and BT4:CH37. These scores will either be NA, 0, 1 or 2. If it is a number, I need to find an overall percentage. Each persons score per item is on one line, so for person 1, C4 :Q4 will have a value of NA, 0 , 1 or 2. (There...

Hi All, I have a list of performance percentage figures which I need to give a score of 0, 1 or 2 depending on whether they improve on a benchmark or not. If a figure is greater than the benchmark figure, a score of 2 is returned. If the figure is lower than the benchmark figure but within...

Hi All, I am currently using an index/match formula to bring score data from one table to another. The problem I am having is that it is assigning a zero value in fields that have no data. This is causing an issues when I am pivoting out the column using that data. We have two set of...

Hi All, I am using an Index/Match to look up value from another table, and using that data to pivot out average scores. However it is placing zeros in the filed that have no data, which is causing Excel to count that cell. What would I need to do so that a zero value is not returned and...

I really hope that someone could help me with this one as I have tried to study videos and still have no idea how to do what I'm looking to achieve, an I apologise if I'm not explaining properly. I have master table of data that I'm looking to develop a report from: <colgroup><col...

I am looking to display the percentile of a value based on multiple conditions. Column K is my score, Column E is my organization, and Column H is my metric. For these, I'd like to see the percentile for each score based on each individual organization and metric.

Hello, I need to subtract baseline score from the most recent score for a specific id. I was filtering and subtracting for each case number but there are too many entries and some have multiple dates. Please help! What is the most efficient way to do this? Formulas? I need it in the D) Results...

Sir, I have table containing Observation and Score. i made a drop down list according the text of observation column. I like to count number of scores comes zero and below zero according the text (observation) <tbody> Observation Score Health_Safety-Electrical<strike></strike> 2...

Is there a formula to find the highest score(s) for Bob in a list with all of his games, and all of his teammates games? Something like "MaxIf" would be perfect, but I don't think it exists. It seems logical, but I'm stumped. If that is possible, can it be taken a step farther to have a...

Good morning! I need help with my table. I have two lines (Raw Score and Relative Rank): <tbody> Raw Score 390 100 660 350 310 Relative Rank </tbody> And I need the second row to list the numbers from highest to lowest. <tbody> Raw Score 390 100 660 350 310 Relative Rank 2 5 1 3...

Hi I have a spread sheet with over 300 names each name has a score (number) I also have a table with 4 levels each level has a number range eg: 14-45. What I am trying to do is pull the names of which level I select eg: level 2 is a range of 6- 12 so I should be able to see all names with a...