horse

  1. E

    Horse Racing Strength

    Hello all, I am looking to produce a rating (number) for a horse based on it's previous race strength figures. In the below example the highest race strength is "19" but i want to be able to rate the horses based on Starting price (lowest to highest) and Last Start Margin ((lowest to highest)...
  2. B

    Copy Multiple Worksheet contents

    Thanks in advance. This is a copy of part of worksheet 1 which is a horse racing rating method: <tbody> Chelmsford City 16.45 (in cell A1) Horse Points Satchville Flyer 233 Irish Times 177 Red Cossack (CAN) 174 Kellington Kitty (USA) 143 Pass The Cristal (IRE) 138 </tbody> On...
  3. M

    Horse racing treble permutations

    Let's say I've selected 10 horses to bet on during a day and I would like to combine them into trebles covering all different permutations. There is more than 1 horse in each race that I want to bet on. For example, Race 1: Horses 6 & 9 Race 2: Horses 2, 4 & 7 Race 3: Horses 1, 3, 5 & 8 I know...
  4. V

    List return

    Hi there - I am looking to create a dynamic list of unique ID numbers for items matching "Horse" in column J, "Ball" in column I, and that do not contain the word dog in column A. In the example below, this would return the ID numbers 48 and 56. However, the formula would be entered into Sheet...
  5. K

    Import data from website into excel using VBA

    Hello, I was wondering if anyone could help For each horse meeting ( Réunion 1, 2, 3 etc. ) I would like a VBA macro to be able to import into exce all the following information from this free website. http://www.geny.com/reunions-courses-pmu?date=2018-08-29 Column A: Date Column B: race...
  6. J

    Moving from VBA to a formula

    I've been working on a project for a while for a friend...he's into horse racing. I know zilch about horses... There's a file that you can purchase, and my friend does, that for each day at a given track has historical data for the past ten races for each horse that is running that day...
  7. M

    Assistance required

    Hi all I am into horseracing and download results via a program which someone did for me, the thing I would like assistance with, is when the names get downloaded they are have in brackets following the name the country where the horse is bred.,but when I do a search it can miss some because of...
  8. M

    Forcast error

    Hi GUYS!!! Trying to do this for a simple horse racing forcast.... I'm having a problem forcasting a horse that stays in same race ( purse ) Can you help? <tbody> 15000 72 18000 66 14000 74 18000 72 18000 67 18000 #DIV/0! FORCAST 20000 58 18000 72 23000 46...
  9. E

    Horse Racing - Win Probability/Place Probability

    Hi All, I am looking for assistance for a mathematical formula to be able to turn my assessed win betting prices (win %) into place betting probabilities. The below should explain the equation a little further. <tbody> W% 2nd % 3rd % Horse 1 35 Horse 2 15 Horse 3 13 Horse 4 10...
  10. S

    Return Corresponding Single Unique Distinct Value From A List Of Sentences

    Hello, Struggling with a heap of text that needs to be sorted. (I have about 10.000 entries in column A) I'm not very proficient in excel, but I believe I need to 1.return single unique distinct values in column C, 2.based on the values in column A 3.with the lookup range being $H...
  11. V

    VBA to insert mutiple lines in the same celll

    Hello all I hope someone can help on this please I am looking for some VBA that will add lines into the same cell. In column "T" I have data that is followed by "," a comma then more data followed by "," a comma Example: dog, cat, horse What I need is dog cat horse but in the same cell...
  12. T

    top rated formula

    hi all what I have is a set of horse racing races with some ratings.(column H)for each race I wont to know which horse is top rated(column H which are green filled).at the moment I can work out the top rated from 1 race at a time with =IF(H5=MAX($H$5:$H$11),"MAX1",""). but what I would like to...

We've detected that you are using an adblocker.

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.
Go back
Back
Top