Hi
I need a formula for COL F please.
COL E returns the max value in COL C for each horse.
In COL F, I need to get the value in the cell adjacent (COL D)
If there is more than 1 max value for a horse (See Chocolate Box) then I the need the higher adjacent value in COL D returned (78 in this case.
Thanks
I need a formula for COL F please.
COL E returns the max value in COL C for each horse.
In COL F, I need to get the value in the cell adjacent (COL D)
If there is more than 1 max value for a horse (See Chocolate Box) then I the need the higher adjacent value in COL D returned (78 in this case.
Thanks
Book2 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Date | Horse | Spd Rat | OR | Max Spd Rat Last 12 months | Adjacent OR | ||
2 | 05/04/2021 | Al Kout | 81 | 80 | 99 | 0 | ||
3 | 17/03/2021 | Al Kout | 90 | 80 | 99 | |||
4 | 02/03/2021 | Al Kout | 66 | 80 | 99 | |||
5 | 11/11/2020 | Al Kout | 91 | 76 | 99 | |||
6 | 18/10/2020 | Al Kout | 99 | 0 | 88 | |||
7 | 07/10/2020 | Al Kout | 85 | 76 | 88 | |||
8 | 21/09/2020 | Al Kout | 79 | 79 | 88 | |||
9 | 21/08/2020 | Al Kout | 3 | 75 | 88 | |||
10 | 18/07/2020 | Al Kout | 55 | 78 | 88 | |||
11 | 27/06/2020 | Al Kout | 85 | 80 | 88 | |||
12 | 09/06/2020 | Al Kout | 88 | 82 | 0 | |||
13 | 05/04/2021 | Cadeau D'Or | 71 | 82 | 89 | 0 | ||
14 | 28/10/2020 | Cadeau D'Or | 81 | 82 | 89 | |||
15 | 02/10/2020 | Cadeau D'Or | 88 | 79 | 89 | |||
16 | 11/09/2020 | Cadeau D'Or | 89 | 0 | 0 | |||
17 | 22/04/2021 | Chocolate Box | 81 | 78 | 84 | 78 | ||
18 | 06/03/2021 | Chocolate Box | 84 | 78 | 84 | |||
19 | 16/02/2021 | Chocolate Box | 84 | 76 | 79 | |||
20 | 01/02/2021 | Chocolate Box | 79 | 78 | 0 | |||
21 | 13/04/2021 | Clongowes | 97 | 100 | 99 | 100 | ||
22 | 04/04/2021 | Clongowes | 99 | 100 | 94 | |||
23 | 04/03/2021 | Clongowes | 92 | 102 | 94 | |||
24 | 04/02/2021 | Clongowes | 50 | 104 | 94 | |||
25 | 13/01/2021 | Clongowes | 94 | 0 | 83 | |||
26 | 07/12/2020 | Clongowes | 83 | 0 | 62 | |||
27 | 08/11/2020 | Clongowes | 62 | 0 | 0 | |||
Sheet1 |