win

Hi I am trying to write a formula that will work out scores for me based on a set of predictions against foot ball scores - I have set out the table below. For each correct result, so for example you predict a 1-0 win and its a 2-1 win you get 1 point. For each correct result and score, so for...

CTRL + Shift + up and CTRL + Shift + dn only moves one row. I am using sticky keys & Win 10 on an Asus ROG gamer.

If you can do this , you are a genius!! formula for a roulette betting system in excel based on the Fibonacci sequence. The sequence goes like this: 1 – 1 – 2 – 3 – 5 – 8 – 13 – 21 – 34 – 55 – 89 – 144 – 233 – 377 – 610 – 987 – … You might have noticed (or you already knew) that each of the...

This appears to ONLY happen with Windows 10 Enterprise 64-bit. MS Office 2016 32-bit The problem is using a Password Char for a textbox. This Windows OS will not read characters in a masked textbox. Is there a way around that? If I remove the character mask then the textbox works fine. But...

Hi all newbie here and not the best with excel or vba :eeek: i am doing a darts scorer with a few macro button(180,140,100) and vlookup (3 dart, 2 dart finishing) which seem to work great :biggrin: so here goes 1, when 501(k21 or m21 reaches 0 it adds +1 value to i5 or o5 1st one to zero wins...

Well hello everyone... I have posted this before, but since i got no replies or help, i thought i would repost it and ask it a bit differently or something. So i have an sheet where i want to keep track of my coinflips.. But to make life easy i want to just write down simple things and then...

Hello everyone, Today I want to make a sheet that contains all the information about coinflips. I am playing a game where coinflipping is a thing and i'm quite addicted to it. Now there is kind of a tactic to get good guesses at it and a big help would be tracking down information. However I...

I have an Access 2010 program that works fine under Win 7 but gives an error message when running under Win 10. The problematic statement appears to be: DoCmd.SendObject acSendNoObject, , , Me.EmailAddress2, , , Me.EmailSubject, Me.EmailContent, False An message appears stating an error has...

Hello, can someone please help with this... I'm trying to get excel to IF function to return to words to W and L without having to manually type it in. Here is an example below. The forecast means, +16 play the over to win and -11 means play the under to win. basically any plus symbol play over...

we are used to to and it does all we want, so are reluctant to update. tried it. didnt like it. so if we update to win 10 from 7/64, will excel 2002 work correctly? thanks all

This is my first post on MrExcel and I really need a hand... I have a multi team game log where the dates are out of order and the data doesn't contain who played who so each team must be handled independently. I'm trying to figure out win streaks and current streaks "for each" team (Should I be...

HI Is it possible to use VLOOKUP to "fetch" the greater than or less than symbol in an IF function. Effectively =If(A1>B1,"WIN","LOSE") would be something like =If(A1"VLOOKUP(C3,D6:E11,2,FALSE)",B1,"WIN","LOSE") Thanks in advance

I have what I consider to be an enormous dataset (approx 150k rows) of NBA player game logs. I'm trying to show the average of the player's previous 3 and 10 game performances. Where I think the real difficulty came up for me is that I would rather not re-arrange the data by changing it to...

I moved from a Win 7 64 bit office 16 64 bit install to a Win 10 office 16 64 bit install. On the Win 7 machine Excel would show Saved in the title bar after a workbook had been saved. It did not matter if I was saving the file locally or on a shared network drive. I am trying to get Excel to...

I was wondering if someone can help me out. I've been using the top set of numbers for a few years while sports betting. However, it seems like all the NJ sites base your betting on how much you will WIN, as opposed to how much you will RISK (on favorites, where the "ML Odds" are -101 and...

Hello all, I need help in the following. I have a sheet with players and the results of their game (in same line) I want to automatically add 1 point if the player won the match (in the points column) and add the number of sets the player won or lost some tennis rules about winning or losing ...

I have searched a ton of posts to find this answer and have not been able to find the scenario that matches mine and works. I want to sort as follows: (There are 300+ Teams in 35+ Divisions) <tbody> Team Division Div Win % All Win % Rank A 1-5A 1.000 .750 1 B 1-5A .500 .800 3 C 2-5A...

Hello, I am trying to count/sum all the wins in column B (consensus picks win column) that match Players A, B and Consensus picks. Panthers -3 vs Cowboys is in players A, B and the consensus column and was a winner (1 in column B). That should count as 1. The correct formula should result...

Hi Everyone, I am trying to calculate my pipeline backwards. I hope I can explain clearly here. The premise is: If I start with 100 USD in my pipeline and I have a win ratio of 20% I will win 20 USD. This 20 USD will move to the next stage (stage A) where there is already another amount...

Hi, I am trying to find the win and loss streaks for set of games to find out whether both teams have scored in match and if so carry it on as a streak. Thank you