Try this. I have altered the column N formula so that it matched the column P formula format. This might make it easier for you if you wanted to extend further beyond 3rd highest.
Colours were just for my benefit in checking
ybr_15.xlsm |
---|
|
---|
| B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q |
---|
3 | | | | | | | | | | | 1st Highest | 2nd Highest | 3rd Highest |
---|
4 | SKU | Title | Category | Contain Box | Rack | WH | | SKU | Title | Category | Rack | WH | Rack | WH | Rack | WH |
---|
5 | 111201.067 | Data 1 | TK | 210 | RA13 | 420 | | 111201.067 | Data 1 | TK | RA13 | 420 | | | | |
---|
6 | 111201.069 | Data 2 | TK | 210 | RA13 | 210 | | 111201.069 | Data 2 | TK | RA13 | 210 | | | | |
---|
7 | 111201.081 | Data 3 | TK | 40 | B32 | 40 | | 111201.081 | Data 3 | TK | B32 | 40 | | | | |
---|
8 | 111201.082 | Data 4 | TK | 60 | B32 | 60 | | 111201.082 | Data 4 | TK | B32 | 60 | | | | |
---|
9 | 111201.083 | Data 5 | TK | 30 | A27 | 30 | | 111201.083 | Data 5 | TK | A27 | 30 | | | | |
---|
10 | 111201.084 | Data 6 | TK | 27 | A27 | 27 | | 111201.084 | Data 6 | TK | A27 | 27 | | | | |
---|
11 | 111201.085 | Data 7 | TK | 110 | A27 | 110 | | 111201.085 | Data 7 | TK | A27 | 200 | A27 | 110 | | |
---|
12 | 111201.085 | Data 7 | TK | 200 | A27 | 200 | | 111201.086 | Data 8 | TK | A27 | 200 | A27 | 90 | | |
---|
13 | 111201.085 | Data 7 | TK Total | | | 310 | | 111201.087 | Data 9 | TK | RA25 | 250 | | | | |
---|
14 | 111201.086 | Data 8 | TK | 200 | A27 | 200 | | 111201.089 | Data 10 | TK | RB05 | 260 | | | | |
---|
15 | 111201.086 | Data 8 | TK | 90 | A27 | 90 | | 111201.091 | Data 11 | TK | A07 | 250 | RA14 | 250 | | |
---|
16 | 111201.086 | Data 8 | TK Total | | | 290 | | 121205.126 | Data 12 | PLATINUM | B24 | 120 | B24 | 24 | B24 | 20 |
---|
17 | 111201.087 | Data 9 | TK | 250 | RA25 | 250 | | 121205.159 | Data 13 | PLATINUM | B30 | 560 | B28 | 120 | B28 | 25 |
---|
18 | 111201.089 | Data 10 | TK | 260 | RB05 | 260 | | 121411.078 | Data 14 | GLOBAL | A11 | 66 | A12 | 66 | RB03 | 66 |
---|
19 | 111201.091 | Data 11 | TK | 250 | A07 | 250 | | | | | | | | | | |
---|
20 | 111201.091 | Data 11 | TK | | RA14 | 250 | | | | | | | | | | |
---|
21 | 111201.091 | Data 11 | TK Total | | | 500 | | | | | | | | | | |
---|
22 | 121205.126 | Data 12 | PLATINUM | 20 | B24 | 20 | | | | | | | | | | |
---|
23 | 121205.126 | Data 12 | PLATINUM | 24 | B24 | 24 | | | | | | | | | | |
---|
24 | 121205.126 | Data 12 | PLATINUM | 40 | B24 | 120 | | | | | | | | | | |
---|
25 | 121205.126 | Data 12 | PLATINUM Total | | | 164 | | | | | | | | | | |
---|
26 | 121205.159 | Data 13 | PLATINUM | 25 | B28 | 25 | | | | | | | | | | |
---|
27 | 121205.159 | Data 13 | PLATINUM | 40 | B28 | 120 | | | | | | | | | | |
---|
28 | 121205.159 | Data 13 | PLATINUM | 40 | B30 | 560 | | | | | | | | | | |
---|
29 | 121205.159 | Data 13 | PLATINUM Total | | | 705 | | | | | | | | | | |
---|
30 | 121411.078 | Data 14 | GLOBAL | 66 | A11 | 66 | | | | | | | | | | |
---|
31 | 121411.078 | Data 14 | GLOBAL | 66 | A12 | 66 | | | | | | | | | | |
---|
32 | 121411.078 | Data 14 | GLOBAL | 66 | RB03 | 66 | | | | | | | | | | |
---|
33 | 121411.078 | Data 14 | GLOBAL Total | | | 198 | | | | | | | | | | |
---|
|
---|