mikemcbain
Board Regular
- Joined
- Nov 14, 2005
- Messages
- 152
- Office Version
- 365
- Platform
- Windows
In the mini sheet below (hope it works my first time trying XL2BB) I require a formula in ColAA which ranks any Rows that are identical in Col's A,B,D,E,F and G. There can be up to 6 rows that may qualify and I would like non-qualifiers to show Blank in AA.
With thanks
Old Mike.
With thanks
Old Mike.
TestMagic.xlsx | |||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | |||
7 | DATE | TIME | REF | NAME | CTRY | RACE | DIST | GRADE | No. | SURNAME | VOL% | VOL2% | RATE | RATED | RORANK | RATVOL | RATVOL2 | RVRANK | RANK | VALUE | OUT | VALU | WL | PL | RANKED | ||||
8 | 04/01/2021 | 00:08 | TEST #7731 | Grace | GB | A6 | 415 | 4 | 15.9 | 15.9 | 118 | 118 | 3 | 1064 | 1064 | 2 | 5.30 | 5.00 | 5.30 | L | -5.00 | ||||||||
9 | 04/01/2021 | 00:27 | TEST #7751 | Timothy | GB | D2 | 261 | 5 | 23.1 | 23.1 | 196 | 196 | 1 | 990 | 990 | 2 | 4.80 | 5.00 | 4.80 | L | -5.00 | ||||||||
10 | 04/01/2021 | 00:32 | TEST #7753 | Angel | GB | B3 | 450 | 2 | 22.8 | 22.8 | 111 | 111 | 3 | 1084 | 1084 | 3 | 1 | 4.40 | 5.00 | 4.40 | W | 17.00 | |||||||
11 | 04/01/2021 | 00:38 | TEST #7756 | Grace | GB | A7 | 415 | 2 | 21.2 | 21.2 | 60 | 60 | 3 | 764 | 764 | 6 | 4.40 | 5.00 | 4.40 | L | -5.00 | ||||||||
12 | 04/01/2021 | 00:43 | TEST #7763 | Timothy | GB | A1 | 450 | 4 | 13.8 | 13.8 | 29 | 29 | 5 | 895 | 895 | 4 | 5.40 | 5.00 | 5.40 | L | -5.00 | ||||||||
13 | 04/01/2021 | 00:58 | TEST #7772 | Timothy | GB | A3 | 450 | 2 | 13.0 | 13.0 | 117 | 117 | 2 | 805 | 805 | 4 | 1 | 4.80 | 5.00 | 4.80 | W | 19.00 | |||||||
14 | 04/01/2021 | 01:03 | TEST #7776 | Simon | GB | A6 | 462 | 1 | 9.1 | 9.1 | 141 | 141 | 2 | 1036 | 1036 | 3 | 1 | 5.40 | 5.00 | 5.40 | W | 22.00 | 1 | ||||||
15 | 04/01/2021 | 01:03 | TEST #7777 | Simon | GB | A6 | 462 | 2 | 10.0 | 10.0 | 69 | 69 | 3 | 942 | 942 | 4 | 5.50 | 5.00 | 5.50 | L | -5.00 | 2 | |||||||
16 | 04/01/2021 | 01:53 | TEST #7806 | Simon | GB | A2 | 462 | 2 | 16.0 | 16.0 | 150 | 150 | 2 | 799 | 799 | 3 | 5.40 | 5.00 | 5.40 | L | -5.00 | 1 | |||||||
17 | 04/01/2021 | 01:53 | TEST #7807 | Simon | GB | A2 | 462 | 4 | 35.1 | 35.1 | 182 | 182 | 1 | 919 | 919 | 1 | 4.80 | 5.00 | 4.80 | L | -5.00 | 2 | |||||||
18 | 04/01/2021 | 02:08 | TEST #7810 | Simon | GB | A3 | 462 | 3 | 22.4 | 22.4 | 27 | 27 | 5 | 836 | 836 | 3 | 5.40 | 5.00 | 5.40 | L | -5.00 | ||||||||
19 | 04/01/2021 | 02:25 | TEST #7817 | Simon | GB | HC | 650 | 1 | 26.1 | 26.1 | 155 | 155 | 2 | 827 | 827 | 2 | 1 | 4.70 | 5.00 | 4.70 | W | 18.50 | 1 | ||||||
20 | 04/01/2021 | 02:25 | TEST #7818 | Simon | GB | HC | 650 | 2 | 19.6 | 19.6 | 286 | 286 | 1 | 798 | 798 | 3 | 5.10 | 5.00 | 5.10 | L | -5.00 | 2 | |||||||
21 | 04/01/2021 | 02:25 | TEST #7820 | Simon | GB | HC | 650 | 4 | 13.1 | 13.1 | 88 | 88 | 4 | 688 | 688 | 5 | 5.10 | 5.00 | 5.10 | L | -5.00 | 3 | |||||||
22 | 04/01/2021 | 02:25 | TEST #7821 | Simon | GB | HC | 650 | 5 | 12.3 | 12.3 | 24 | 24 | 5 | 788 | 788 | 4 | 6.00 | 5.00 | 6.00 | L | -5.00 | 4 | |||||||
23 | 04/01/2021 | 03:03 | TEST #7839 | Simon | GB | D4 | 268 | 3 | 6.4 | 6.4 | 109 | 109 | 3 | 817 | 817 | 3 | 1 | 5.50 | 5.00 | 5.50 | W | 22.50 | |||||||
24 | 04/01/2021 | 03:22 | TEST #7849 | Simon | GB | A4 | 462 | 4 | 10.7 | 10.7 | 30 | 30 | 5 | 830 | 830 | 3 | 6.00 | 5.00 | 6.00 | L | -5.00 | 1 | |||||||
25 | 04/01/2021 | 03:22 | TEST #7851 | Simon | GB | A4 | 462 | 6 | 12.6 | 12.6 | 242 | 242 | 1 | 902 | 902 | 1 | 6.00 | 5.00 | 6.00 | L | -5.00 | 2 | |||||||
26 | 04/01/2021 | 03:42 | TEST #7862 | Simon | GB | A2 | 462 | 6 | 25.5 | 25.5 | 96 | 96 | 3 | 721 | 721 | 2 | 4.30 | 5.00 | 4.30 | L | -5.00 | ||||||||
27 | 04/01/2021 | 04:02 | TEST #7867 | Simon | GB | D1 | 268 | 1 | 18.9 | 18.9 | 135 | 135 | 2 | 811 | 811 | 1 | 1 | 5.70 | 5.00 | 5.70 | W | 23.50 | 1 | ||||||
28 | 04/01/2021 | 04:02 | TEST #7871 | Simon | GB | D1 | 268 | 5 | 18.4 | 18.4 | 14 | 14 | 5 | 573 | 573 | 4 | 5.40 | 5.00 | 5.40 | L | -5.00 | 2 | |||||||
29 | 04/01/2021 | 05:16 | TEST #7900 | Paul | GB | A10 | 460 | 2 | 17.0 | 17.0 | 125 | 125 | 1 | 1044 | 1044 | 1 | 5.00 | 5.00 | 5.00 | L | -5.00 | 1 | |||||||
30 | 04/01/2021 | 05:16 | TEST #7901 | Paul | GB | A10 | 460 | 3 | 21.0 | 21.0 | 78 | 78 | 4 | 998 | 998 | 2 | 5.80 | 5.00 | 5.80 | L | -5.00 | 2 | |||||||
31 | 04/01/2021 | 05:16 | TEST #7903 | Paul | GB | A10 | 460 | 5 | 11.2 | 11.2 | 119 | 119 | 2 | 853 | 853 | 3 | 5.70 | 5.00 | 5.70 | L | -5.00 | 3 | |||||||
32 | 04/01/2021 | 05:18 | TEST #7906 | Eunice | GB | A3 | 476 | 2 | 20.3 | 20.3 | 107 | 107 | 2 | 884 | 884 | 4 | 5.40 | 5.00 | 5.40 | L | -5.00 | ||||||||
33 | 04/01/2021 | 05:27 | TEST #7914 | Harper | GB | D1 | 265 | 4 | 22.8 | 22.8 | 20 | 20 | 5 | 665 | 665 | 6 | 1 | 4.70 | 5.00 | 4.70 | W | 18.50 | |||||||
34 | 04/01/2021 | 05:32 | TEST #7917 | Paul | GB | A9 | 460 | 2 | 23.3 | 23.3 | 99 | 99 | 3 | 956 | 956 | 4 | 4.70 | 5.00 | 4.70 | L | -5.00 | ||||||||
Sheet1 |