score

Hi guys, First post on this forum . I have a table with a list of initiatives - First column: the number of the initiatives - Second: Description of initiative - Third: Type of initiative (3 different types: digital tool, IT change, Process change) - Fourth: Impact score (0-5) - Fifth...

I am working on a golf spreadsheet. How do I count the eagles, birdies, pars, bogeys, dbl bogeys, other score in separate columns from the Par and Score columns below. <tbody> A B C D E F </tbody> <tbody> Par Score Eagles Birdies Pars Bogeys dbl bogeys Others 4 4 5 6...

Hi,Some help please. I've looked at LOOKUPs, IF, ANDs and I can't seem to figure out the correct formula to use. Column A contains a half year score and Column B contains a full year score, Column C is the 'reference' for the final year score. I'm looking for a formula/way for excel to return...

Hi I want to provide text result based on students score but also I want to modify the score and add bonus based on the score and put the new result in "new score" column. The conditions are the following If the score is >20 = very good ( they get a 5% performance bonus) If the score is 16-20 =...

I am in desperate need of help. I am a novice at excel formulas. I need to write a formula that will pull from a set of data the separates between a Male or Female, Number of Push Ups and then provides a score...so for example: <colgroup><col style="width:48pt" width="64" span="4">...

Hello, I would like to format cells based on the value in another cell. Eg, column A has names of staff. column B gives the score from an assessment. I would like the name (column A) to change to red if the score in column B is 1. I'd like the name to change to orange if the score in column...

Hi, I'm trying to calculate a weighted credit score for the credit ratings I have in my bonds portfolio. The first table represents the different S&P credit ratings (column A) and their arbitrary scores (B). The second table represents the bonds I have, the investment in each bond (C), their...

I am nearing the end of small project for a golf club and need some help. In this spreadsheet teams\players are listed in column “E”. The individual golf holes are listed in Columns F, G, H, I, J, K, L, M, N, P, Q, R, S, T, U, V, W, X Teams\Players participating in the skins game are marked...

Hi Team, I have Data in range("A1:D9"), I want to extract Scores and Sixes, in column h and I. I Know how to get it via vlook up in VBA, My data is huge 1lacks row. I want the result via vba Dictinary/Collection, Just started learning. Thanks for your help in Advanc A B...

hello again, I am wondering if it is possible to auto sort rows in a score sheet. I have a golf score sheet which comprises 13 rows. Each row contains 22 cells and the total for each player is calculated in the 23rd cell. Its difficult to explain, ideally I would like to post a snap shot of the...

Hi there, Hoping someone can help, wondering if this is possible without the use if VBA/macros.... To set the scene I am looking at a tennis match, and counting where a player hits a return dependent on where the serve lands. I have a drop down menu already that allows the user to select the...

I’m trying to use a bunch of if / and statements to work on the following problem but it isn’t really getting me anywhere. The premise of what I’m working on is that certain things have taken place in the past, and depending on how long ago it happened, it gets a certain score. - If it...

I'm working on creating a golf scorecard that can keep track of multiple side games. I'm having trouble with one called Vegas or Casino. In said game, two man teams compete against each other by combining their scores into one number. For example: Player A = 4 Player B = 5 Team 1 score of 45...

I think my formula may require MAX INDEX and MATCHsomehow, but I’m stumped. I need to look at the earliest date and the latest date against memberslisted below (dates in between should be ignored). Ineed to then compare the Total Score against the earliest and latest date andif the Total...

Hi, I'm looking to apply some simple conditions to return a typical Red, Amber & Green (RAG) analysis. The 3 conditions are set out below the table. The problem one is the Amber condition as it has two metrics and this is the one that I struggled to incorporate into a Conditional Formatting...

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, For the most part I am quite proficient in Excel, but there's something I am trying to achieve but don't exactly know how to and what approach to take. I am making a D&D sheet for a games night I have next week and I wanted to have a hidden page that calculate's whose turn it is based on...

Hello there, I'm attempting to use SUMIFs with dynamic rows or columns, here is a sample dataset <tbody> Score 1 Score 2 Score 3 Score 4 Score 5 Student 1 8 2 5 3 6 Student 2 6 4 4 0 3 Student 3 4 2 3 3 5 Student 4 7 2 2 3 5 Student 5 6 0 2 2 3 Student 6 6 0 5 3 6 Student 7 7...

Hi, I am trying to transfer data to an external file from a worksheet using VBA: current date, username and a global range named cell "Score". Date and username is succesfully transfered to column A and B in the first empty row. "Score" however gives me an error. I don't know how to refer to...

Is it possible to do this? I have this sheet <tbody> Team NAMES SCORE T1 JOHAN 1 T1 ANNA 23 T1 MARIA 3 T2 BENJAMIN 5 T3 OLOF 55 T1 LARS 16 T3 LISA 12 T3 OSKAR 5 </tbody> Id like to get the top 3 highest scores. of each team. I want to present the...