Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- Windows
Hello all,
I have this function that PeterSS provided for me .
It does give correct result but only on last entry . The cells in col HK in blue
should be zero .
I hoping to get a small amendment to give me the results I have in col HK .
Col Z should be returning zero if there is no number 1 or 1= in col V .
I have hilghted in red col HK correct results .
Thanks .
I have this function that PeterSS provided for me .
It does give correct result but only on last entry . The cells in col HK in blue
should be zero .
I hoping to get a small amendment to give me the results I have in col HK .
Col Z should be returning zero if there is no number 1 or 1= in col V .
I have hilghted in red col HK correct results .
Thanks .
Excel Workbook | |||||||
---|---|---|---|---|---|---|---|
F | V | Z | AD | HK | |||
1 | Date | Placing | Jwin | Jockey | Result | ||
2 | 1/08/2013 | 6 | 0 | Jo Rathbone | 0 | ||
3 | 1/08/2013 | 1 | 1 | Buddy Lammas | 1 | ||
4 | 1/08/2013 | 7 | 0 | Gary Walsh | 0 | ||
5 | 1/08/2013 | 8 | 0 | Shannon Doyle | 0 | ||
6 | 1/08/2013 | 2 | 0 | Charlie Studd | 0 | ||
7 | 1/08/2013 | 5 | 0 | Kayla Veenendaal | 0 | ||
8 | 1/08/2013 | 4 | 0 | Isaac Lupton | 0 | ||
9 | 1/08/2013 | 3 | 0 | Aimee Taylor | 0 | ||
10 | 1/08/2013 | 5 | 0 | Jo Rathbone | 0 | ||
11 | 1/08/2013 | 6 | 0 | Niall Quinn | 0 | ||
12 | 1/08/2013 | 3 | 1 | Buddy Lammas | 0 | ||
13 | 1/08/2013 | 4 | 0 | Rory Hutchings | 0 | ||
14 | 1/08/2013 | 7 | 0 | Shannon Doyle | 0 | ||
15 | 1/08/2013 | 1= | 1 | Kane Smith | 1 | ||
16 | 1/08/2013 | 2 | 0 | Gary Walsh | 0 | ||
17 | 1/08/2013 | 1 | 1 | Lisa Whelan | 1 | ||
18 | 1/08/2013 | 5 | 0 | David Walker | 0 | ||
19 | 1/08/2013 | 4 | 1 | Buddy Lammas | 0 | ||
20 | 1/08/2013 | 3 | 0 | Hayden Tinsley | 0 | ||
21 | 1/08/2013 | 2 | 0 | Darryl Bradley | 0 | ||
22 | 1/08/2013 | 6 | 0 | Mereana Hudson | 0 | ||
23 | 1/08/2013 | 3 | 0 | Johnathon Parkes | 0 | ||
24 | 1/08/2013 | 6 | 1 | Buddy Lammas | 0 | ||
25 | 1/08/2013 | 4 | 0 | Dylan Turner | 0 | ||
26 | 1/08/2013 | 5 | 1 | Lisa Whelan | 0 | ||
27 | 1/08/2013 | 1 | 2 | Buddy Lammas | 2 | ||
28 | 1/08/2013 | 2 | 0 | Amanda Morgan | 0 | ||
29 | 1/08/2013 | 1 | 3 | Buddy Lammas | 3 | ||
30 | 1/08/2013 | 4 | 0 | Kei Chiong | 0 | ||
31 | 1/08/2013 | 3 | 0 | Rory Hutchings | 0 | ||
32 | 1/08/2013 | 7 | 0 | Hayden Tinsley | 0 | ||
33 | 1/08/2013 | 8 | 0 | Bridget Grylls | 0 | ||
34 | 1/08/2013 | 1 | 2 | Kane Smith | 2 | ||
Sheet1 |