# Search:

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

1. ## Thread: Redistribute Values Formula Advice

by ExcelRaceRatings
Replies
3
Views
75

### 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. ## Thread: Redistribute Values Formula Advice

by ExcelRaceRatings
Replies
3
Views
75

### 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. ## Thread: One Minus The Next Highest Number

by ExcelRaceRatings
Replies
2
Views
156

### Re: One Minus The Next Highest Number

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

by ExcelRaceRatings
Replies
2
Views
156

### 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. ## Thread: Horse Racing Strength

by ExcelRaceRatings
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. ## Thread: Minus from the lowest value in column

by ExcelRaceRatings
Replies
2
Views
117

### Re: Minus from the lowest value in column

Perfect!!

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

by ExcelRaceRatings
Replies
2
Views
117

### 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. ## Thread: Horse Racing - Win Probability/Place Probability

by ExcelRaceRatings
Replies
0
Views
1,235

### 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. ## Thread: Average Top 10 Values Only

by ExcelRaceRatings
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. ## Thread: Average Top 10 Values Only

by ExcelRaceRatings
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. ## Thread: Lookup Error Issue

by ExcelRaceRatings
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. ## Thread: Assign A Word To Specific Set Of Text

by ExcelRaceRatings
Replies
1
Views
161

### 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. ## Thread: Scaling a set of numbers

by ExcelRaceRatings
Replies
3
Views
206

### Re: Scaling a set of numbers

Great work igold!
14. ## Thread: Scaling a set of numbers

by ExcelRaceRatings
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