won

Hi all I have a raw data table and using sum and countifs to calculate answers. The 2 following formula should in theory return the same answer however the first formula gives the correct answer, but the second formula using not equal to (<>) for 'point won by' is giving the wrong answer...

Hi I am running a change event macro. I have a column on the sheet, where the user changes a value from "Hot" to "Won". What I would like to happen is when this happens, a macro will run. Thanks in Advance.

Hello MrExcel, I'm stuck on an issue. I have a log of quoted parts and a log of sales on separate tabs. The quote log has a date range for each quote, and the sales log has a date of sale. Both have part numbers for each. I'm trying to have my quote log match criteria and return whether or not...

I have a 10 x 10 range of cells that are numbered 1-100 (Squares for NCAA Pool). On another tab in the same workbook I have a "winners column" which is formula based that returns which cell won based on a search. To provide a visual of how many different cells have won I would like to...

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...

lottery. i can get the rows of 6 numbers that have won before. how do i check if any set of 6 numbers (or maybe 5) have won more than once? than if none have then i should not choose a set of numbers that have won. how do i do that? In excel 2002 how do i post a spreadsheet in this forum...

Hi, I've been searching for an answer to this for a while but can't work it out, so I'm calling for help! (BTW, I'm using Google Sheets) I've a list of football results, and I'm trying to calculate the longest unbeaten run. Column A shows the result (Won, Lost, Drawn). I'd like column B to...

Hi all, Apologies in advance for the excessive post, but hope it makes sense. I am in the process of analysing a tennis match. I would like to look at how many times a player wins just 1 point at a time, 2 points in a row, 3 in a row 4 in a row and 5+ points in a row. From my raw data is have...

Hy guys need help on a tricky one, i guess <tbody> TEAM 1 21 X 18 TEAM 2 TEAM 3 15 X 21 TEAM 4 TEAM 1 16 X 21 TEAM 3 TEAM 2 21 X 16 TEAM 4 TEAM 4 21 X 16 TEAM 1 TEAM 3 21 X 12 TEAM 2 </tbody> I now need to rank them, this is what i have so...

Hi, looked for forum to find answer for my question but didn't manage to find solution. I would like to find 5 top values from data, based on certain criteria. I also need way to present results, if there is a tie between 2 values, when status is same for both (for example companies: Foxtrot and...

Dear all, Please advise, is there any way to calculate the following task with excel? In document https://docs.google.com/spreadsheets/d/18wuUFxV_0p2Cr0G8xA4O2e0qi_lW0K060vM6RnDnCzU/edit?usp=sharing, There are 3 players. We are playing pingpong games. Each day we play two tournirs. In each...

Good morning all, I currently have a worksheet which I use to log quote requests received. For reasons that are beneficial elsewhere if there are multiple items on the quote for the same company each item is added to a new row the log but using the same identifying order number. i.e Status...

<tbody> <tbody> 0 Aces 1 #F0F0F0[/URL] "] 5 Double Faults 1 68% 1st Serve Percentage 70% #F0F0F0[/URL] "] 47% (22/47) 1st Serve Points Won 50% (19/38) 41% (9/22) 2nd Serve Points Won 63% (10/16) #F0F0F0[/URL] "] 30% (3/10) Break Points Saved 0% (0/4)...

Excellists, I have a table in sheet1 of workbook as shown below. Ik want to add a Command_button that shows a list active projects (Column = Status = WIP) per person (Column = BC = Naam1 or Naam2 or Naam3 etc.). The result could be a msgbox or a listbox; i don't really care. To start i need to...

Hi All Can someone please help me. in below table Column D is data validated only to have "won" or "fail" , I need a vlookup formula in column D which will look status of column A in column C and if it should result if it is Won or failed, if there is any other value other than won or fail it...

Hey there. Long time since I have posted something and became stuck on something. I want to track Wins and Losses for a set of baseball teams. Every game will have a W or an L Go back 10 games and tell me the % of those games that team has won Also, Go back 25 games and tell me the % of those...

Good afternoon ladies and gentlemen. I am looking for a formula which will return a different cell value based on two IF\AND criteria. i.e I have three columns in the worksheet and one of the cells in one of the three columns titled "live", "lost" "won" (AB, AC, & AD). There will be a...

Hello I have a basic understanding of spreadsheets and formulas but am out of my depth and need your help and advice! I have a workbook that has multiple spreadsheets. The first is a summary sheet, the others are for each year. I would like the summary sheet to show the number of times a...

I am having a problem with my formula. I have a wrestling record book that I am trying to get points for. Example if a person won a match with a pin I want them to get 4 points. If they Lose a match they lose .5 points. I want to be able to add up points for Wins/Loses and How they won. The...

I am trying to automate a badminton league match scoresheet. I can use a SUM to calculate the total points scored, and SUMPRODUCT to work out total games won, but I then need to count up the number of 'best of threes' won. eg: First set may look like this: 21 - 19 10 - 21 21 - 19 Second set: 10...