horses

  1. 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...
  2. 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...
  3. K

    excel vlookup or index with if

    I uploaded the file so basically formula should look into column a first example it would look into A2:A12 because its one race with 11 horses it should into if AR2:AR11=1 and BT2:BT11<3 and it should the same time look if in the same race Power 2 AR2:AR11= 2 AP2:AP11<3 and BT2:BT11<3 then bet...
  4. B

    Sort variable number of rows by column

    Help greatly appreciated on this. Below is a simple representation of a larger data set. I wish to sort each block of rows by column with the numerical value in Col. B descending from Largest to Smallest. <tbody> Col. A Col.B To give result: Col. A Col.B Birds 9 Dogs 14 Dogs 14...
  5. C

    Data Extraction Help Via Formula

    Hi All I have a spreadsheet I receive each day with a list of horses that are running that day with various pieces of information pertaining to their previous runs on row by row basis. What I would like to do is extract each row of data in relation to the horses I am interested in. By that I...
  6. S

    Formula to find smallest number in a list

    I have a list of horses names in column G with their race times in column AD. There are multiple entries for the horses (i.e. they have up to 6 races and times. There are also multiple races. In column X I have managed to get the horse name listed just once with blanks for all the other...

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