pool

I wish to create a scoreboard for pool matches on a live stream as an overlay image. I was thinking of using an external button box to change the variables within an excel file which then in turn changes said variables on my overlay. The variables I would require would be: Player 1 name...

Hello, I am doing a masters pool with friends where we are each going to get 1 player. There are 86 players in the masters field and 86 people participating in the deal. How can i match the two randomly?

HI :-) I've got a spread sheet with text data. I need a formula to search for any instances of a text string "2017, 2018 or 2019" & get a FAIL output in the adjacent column. I get success with the below formula but i just cant get / re work it to search for three different words, e.g. 2017...

Is there a for me (non literate Excel user) to extract a number of questions from a pool of test questions in Excel? The questions have in the first column numbered 1-200 I would like to pick random questions, say 52, for each person from that pool of questions. Then the next person would...

Hi all, I would like to use a VBA code, so that to run through col “G” and where find bold text should “SUM” the col. “I” less col. “J” in adjacent cell in col."K". Therefore, that the data start from row “7” and are more than 400000. Thank you in advance Original data <!--[if gte mso...

Hi all, I would like to use a VBA code, so that to run through col “G” and where find the text “Opening Balance”, should move the number in adjacent cell from col. “I” to col. “H” Therefore, that the rows are 100000+. I present below the original data and the expected result. Thank you in...

Hi all, I would like to use a VBA code, so that to run through col “B” and where find the name of each department, e.g. Restaurant, Pool bar e.t.c., should place it in col. “F” and rows down for each department’s records. Therefore, that the rows are 100000+. I present below the original data...

Looking for a formula to calculate a pool player’s averages in a pool league…. Players play a 9-ball match, set of games. Each pocketed ball (1 thru 8) is worth 1 point, with the 9 ball being worth 2 points. Players have a skill level (S/L) ranging from 0 thru 10, in .25 increments. [6.00...

Hi all, I would like to write a VBA code so that, to run through col. “F” and rows down and where exist bold descriptions should move them to adjacent cells in col. “A” Therefore, that the code should start from “F11”. Below I present the original data and the expected result. Thanking...

Hi all, I would like to write a VBA code so that, to run through col. “F” and rows down and where exist bold descriptions should move them to adjacent cells in col. “A” Therefore, that the code should start from “F11”. Below I present the original data and the expected result. Thanking you...

I am stumped on this and don't know where to start. I am looking to create a form where it tracks time used (simple...) However, in 366 days that time will be added back to the pool. . I was able to do this with one date but a running list caused issue. Pool starts at 48. Each time you...

I Want to make a formula using following : No of Days Total amount Loan Deduction Cumulative balance 30 4000 5000 -1000 This -1000 is then given to employee from pool of investment . if it goes on 60 days The balance in cumulative should be zero...

Hi I have been roped in to do a pool league team sheet , what I cant work out is how to add 2 points to winning teams weekly result ie team a 5 team b 2 so team a has 5 plus two for winning it should be easy but can not get head round it

Hello all, I'm trying to put together a general payout schedule for office pools showing percentages that each place would get paid out depending on # of entries. Looking to put together something that can range from 10-300 entries and show payout %'s for either 10 or 15% of total entries...

Hi all, I am having difficulty trying to create a fixture list for a pool league i'm running. I know I could do it manually but this would take a bit of time and would like to try automate it as much as possible. The problem I face is there is 3 instances where 2 teams share the same venue...