I have the following sub which copies and pastes a range of data which has been input by user on one sheet (Input) and appends it on (All Scores), which is a master sheet of a thousand or so players and a weekly score over a forty week season. The probelm is with zeros. I have set the workbook...
I'm trying to rank some stats. The problem is that I don't want to encourage blind use of a particular work related function, and so I only want to count up to 100%, anything over 100% should be considered as 100%.
However I also need to display the actual results still, so I cant just edit...
Hello,
First let me give you a little background on my problem. This is my first post in this forum. I have tried to find a solution to my problem by searching the web and several forums. However, I have not found one. I have been able to get some segments to work but need some assistance to...
Hi All,
First time on the site but I have faith in the collective.
Excel 2016
Problem : A Golf Score Spreadsheet. After inputting the scores, Totals are given at the bottom for Front Nine Score and Back Nine Scores. "Total Out" Cell (F33) function is =Sum(F14:F22) Below that (F34) is...
Hi all,
I am struggling a little to make a COUNTIFS or SUMIFS formula work on my spreadsheet.
I am trying to count the amount of errors made depending on the category. I have the scores in one tab and the table containing the number of errors in another.
So.... My current formula is below...
Hello. This may not be possible but I'll ask anyway as I've not been able to work it out myself... :(
I have a table which collates scores and calculates the total score as percentage. These percentage cells are spread out over one row, but over multiple separated columns because there are...
Hi, am hoping someone can point me in the right direction...
I have created an excel based audit tool for hospitals. It takes scores from staff and managers in response to around 30 questions. These are combined and triangulated to produce a lovely dashboard / performance summary... All good so...
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...
Hello. I have a spreadsheet which collates scores received and calculates a weighted average based on a number entered into a reference cell. The point of this sheet is to record scores received for projects after they have completed.
What I cannot understand is how to get the formula to ignore...
Hello,
I have a list of scores for a game competition, that are summed in one cell per player.
All scores contains two decimals.
<tbody>
A
B
1
264,07
7,00
2
279,57
3,00
3
225,05
13,00
4
268,90
4,00
5
280,63
2,00
6
225,05
15,00
7
225,05
16,00
8...
<tbody>
ID
Score1
Score2
Score3
Score4
A
1
1
2
1
B
1
3
2
4
</tbody>
Hi all,
I'm attempting to do some sensitivity analysis on a model I've built.
My data is set out as in the above table, with scores being either 1, 2, 3 or 4.
The scores are then weighted, and a total...
Hoping someone can help - I'm sure this is simple and I'm just dim!
I have a spreadsheet that records candidates (one per sheet) and the scores they achieve on 3 tests, each test consisting of multiple elements.
Each sheet will sum that candidates scores across the elements and give a total...
I am way in over my head. I'm trying to make a spreadsheet for our future events that would automatically rank the people via the highest of three scores. In case of ties, it will then compare the other two scores to see who had the highest one there. If there are still ties, then whoever...
I have a list og Golfers , each we we record their points to determine their rank for the following week . Currently we open a spreadsheet and enter their scores for the week , the spreadsheet calculates the average from the top 3 scores from the five most recent scores. All of this works fine...
Hi again All!I have a worksheet - column A is a list of actual football scores in the format digit.space.digit such as >1 1<.Column B is a list of score predictions, in the same format.Column C is looking for identical matches - i.e. where the score is an exact match and I use the following...
Hello,
I'm trying to make a formula like this in order to refer to scores in my "Scores" sheet form a different sheet:
=INDEX(Scores!$A$1:$AP$55,MATCH($A5,Scores!$A$2:$A$55,0),INDIRECT("Scores!"&"COLUMN((TODAY()-WEEKDAY(TODAY(),2)+5))"))
But I can't get the bold part to work correctly in...
Hello,
In my tables of scores, I sometimes need to know how many times each student had scores that were below or above a particular score or within a certain range. (It's a growing table such that each week I add a new column at where column B is.) All weeks are indicated per column by the...
Hello.
My request is relatively straight forward in excel terms but I am trying to work out how to automatically highlight a cell in a score sheet.
For example there are a list of 10 players and each players scores are accumulated. As these scores get higher or in the case of a golf score...
This is the code that is on the worksheet "Scores" with all the data.
=IFERROR(INDEX(Entry,MATCH(1,(B56=Div)*(B57=Model)*(MAX(IF(Div=B56,IF(Model=B57,Pts)))=Pts),0)),"x")
I want to display the results on another worksheet.
"Entry" is the piece of data I want displayed on another worksheet. I...
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>I have the following score bands (column C) and their associated categories (column D). I also have a list of scores of several hundred individuals. For example, if there's an individual that...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.