Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- Windows
Im trying to get the same results I have in cols BJ and BK .
The function needs to acknowledge col AH somehow .
Thanks .
The function needs to acknowledge col AH somehow .
Thanks .
Excel Workbook | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
AH | AL | AO | BI | BJ | BK | BL | BM | |||
1 | HorseName | Finishingposition | Decimalmargin | Xup | Pl | Mg | A | B | ||
2 | Bahhare Babe | 11 | 9.2 | 1 | ||||||
3 | Bahhare Babe | 2 | 3 | 1 | 11 | 9.2 | 11 | 9.2 | ||
4 | Bahhare Babe | 9 | 6.7 | 1 | 2 | 3 | 2 | 3 | ||
5 | Bahhare Babe | 4 | 1.3 | 2 | ||||||
6 | Bahhare Babe | 12 | 10.3 | 3 | ||||||
7 | Bahhare Babe | 13 | 10.2 | 1 | 9 | 6.7 | 9 | 6.7 | ||
8 | Bahhare Babe | 5 | 1.4 | 2 | 4 | 1.3 | 4 | 1.3 | ||
9 | Bahhare Babe | F | F | 1 | 13 | 10.2 | 13 | 10.2 | ||
10 | Sarbara Ann | 2 | 0.5 | 1 | F | F | ||||
11 | Sarbara Ann | 1 | 0.4 | 2 | 5 | 1.4 | ||||
12 | Sarbara Ann | 3 | 6.2 | 3 | 12 | 10.3 | ||||
13 | Sarbara Ann | 8 | 2.4 | 1 | 2 | 0.5 | 2 | 0.5 | ||
14 | Sarbara Ann | 4 | 2.6 | 2 | 1 | 0.4 | 1 | 0.4 | ||
15 | Sarbara Ann | 4 | 1.9 | 1 | 8 | 2.4 | 8 | 2.4 | ||
16 | Sarbara Ann | 5 | 1.8 | 1 | 4 | 1.9 | 4 | 1.9 | ||
17 | Sarbara Ann | RO | RO | 2 | 4 | 2.6 | 4 | 2.6 | ||
18 | Sarbara Ann | 1 | 0.1 | 3 | 3 | 6.2 | 3 | 6.2 | ||
19 | Farbaric | 10 | 17 | 1 | 5 | 1.8 | ||||
20 | Farbaric | 1 | 3.8 | 1 | 10 | 17 | 10 | 17 | ||
21 | Farbaric | 2 | 0.5 | 2 | RO | RO | ||||
22 | Farbaric | 2 | 0.3 | 3 | 1 | 0.1 | ||||
23 | Farbaric | 6 | 1.7 | 4 | ||||||
24 | Farbaric | 1 | 1.7 | 1 | 1 | 3.8 | 1 | 3.8 | ||
25 | Farbaric | 4 | 4.1 | 2 | 2 | 0.5 | 2 | 0.5 | ||
26 | Farbaric | 1 | 0.1 | 3 | 2 | 0.3 | 2 | 0.3 | ||
Sheet1 |