Search:

Type: Posts; User: ExcelRaceRatings; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Redistribute Values Formula Advice

    Hi Peter,

    Thanks for your response.

    Evenly redistributing the values among the remaining as you have shown in Column B would my the path i would like to go down.
  2. Redistribute Values Formula Advice

    Hello,

    I am looking for advice with a mathematics formula. Say in Cells A1:A4 i have the below 4 percentage values:

    A1 - 45%
    A2 - 25%
    A3 - 20%
    A4 - 10%
    Total - 100%
  3. Re: One Minus The Next Highest Number

    Yep perfect, well played!
  4. One Minus The Next Highest Number

    Hello,

    I am looking for advice on a formula to basically minus one from the next highest number.

    If A1 to A8 have the numbers:

    3
    5
    1
    8
  5. Replies
    1
    Views
    253

    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...
  6. Re: Minus from the lowest value in column

    Perfect!!

    Appreciate your help!
  7. Minus from the lowest value in column

    Hi all,

    I am hoping to find a formula that will subtract each value in a column (B2:B25) directly from the lowest value in that column.

    Example:

    Column B
    59
    54
    56
  8. 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...
  9. Replies
    4
    Views
    332

    Re: Average Top 10 Values Only

    Hi there,

    Below is a small smaple of what i require. Remember there are 62 values all up in Column A under "Flem 1200 4". I am after simply an AVG of the top 10 only is possible?



    <tbody>...
  10. Replies
    4
    Views
    332

    Average Top 10 Values Only

    Hi All,

    I have a large spreadsheet containing race times from Horse Racing tracks all around Australia. I want to able to average the top 10 times sorted by: track, distance and track condition. ...
  11. Replies
    1
    Views
    173

    Lookup Error Issue

    Good morning all,

    I have a spreadsheet set up where in B26:B52 I have a mathematical sum that produces a value between 0-100 based on another set of cells. In C26:C52 I have a blank set of cells...
  12. Assign A Word To Specific Set Of Text

    Hi there,

    Hoping someone can help with the below issue:

    I have a set of words in A1:A5

    A1 - Apple
    A2 - Bacon
    A3 - Banana
    A4 - Water
  13. Replies
    3
    Views
    206

    Re: Scaling a set of numbers

    Great work igold!
  14. Replies
    3
    Views
    206

    Scaling a set of numbers

    Hi there,

    I have a set of three numbers:

    Cell AJ43 - 32
    Cell AJ44 - 22
    Cell AJ45 - 18
    Total 72

    I want to be able to scale these numbers so they add to 100.
Results 1 to 14 of 14