JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Sorting data by product group
Hi,
I am trying to sort a list of data where I can identify the top 10 sales by product group.
I have several product groups A – E along with sales in each group.
Each product group has over 10 sales recorded against each group
I want to easily sort the top 10 sales in each product group
Below is an example of what the data looks like.
I want to sort the top 10 sales in each product group
Product Sales PRODUCT A £ 584,794 PRODUCT A £ 388,073 PRODUCT A £ 383,689 PRODUCT A £ 342,863 PRODUCT A £ 336,309 PRODUCT A £ 307,654 PRODUCT A £ 259,484 PRODUCT A £ 225,525 PRODUCT A £ 221,328 PRODUCT A £ 220,059 PRODUCT A £ 197,443 PRODUCT A £ 195,582 PRODUCT A £ 183,702 PRODUCT A £ 183,231 PRODUCT A £ 179,651 PRODUCT A £ 175,929 PRODUCT A £ 155,360 PRODUCT A £ 152,893 PRODUCT A £ 127,054 PRODUCT A £ 124,859 PRODUCT B £ 116,724 PRODUCT B £ 106,979 PRODUCT B £ 89,422 PRODUCT B £ 74,994 PRODUCT B £ 73,020 PRODUCT B £ 72,481 PRODUCT B £ 65,808 PRODUCT B £ 65,540 PRODUCT B £ 60,228 PRODUCT B £ 57,010 PRODUCT B £ 56,915 PRODUCT B £ 45,120 PRODUCT B £ 40,169 PRODUCT B £ 32,320 PRODUCT B £ 31,973 PRODUCT B £ 31,502 PRODUCT B £ 29,754 PRODUCT B £ 27,215 PRODUCT B £ 27,208 PRODUCT C £ 24,680 PRODUCT C £ 23,973 PRODUCT C £ 22,342 PRODUCT C £ 19,884 PRODUCT C £ 19,060 PRODUCT C £ 17,835 PRODUCT C £ 14,913 PRODUCT C £ 14,649 PRODUCT C £ 13,778 PRODUCT C £ 13,179 PRODUCT C £ 12,318 PRODUCT C £ 11,798 PRODUCT C £ 9,469 PRODUCT C £ 9,331 PRODUCT C £ 8,157 PRODUCT C £ 7,258 PRODUCT C £ 6,676 PRODUCT C £ 5,417 PRODUCT C £ 4,034 PRODUCT C £ 3,160 PRODUCT C £ 2,817 PRODUCT C £ 2,625
<tbody>
</tbody>
Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
A
B
C
D
E
1
Product
Sales
Rank
Top 10
2
PRODUCT A £ 584,794 1
TRUE
C2: {=SUMPRODUCT(--(B2 < IF(A$2:A$62 = A2, B$2:B$62, 0))) + 1} 3
PRODUCT A £ 388,073 2
TRUE
D2: =C2<=10 4
PRODUCT A £ 383,689 3
TRUE
5
PRODUCT A £ 342,863 4
TRUE
6
PRODUCT A £ 336,309 5
TRUE
7
PRODUCT A £ 307,654 6
TRUE
8
PRODUCT A £ 259,484 7
TRUE
9
PRODUCT A £ 225,525 8
TRUE
10
PRODUCT A £ 221,328 9
TRUE
11
PRODUCT A £ 220,059 10
TRUE
12
PRODUCT A £ 197,443 11
FALSE
13
PRODUCT A £ 195,582 12
FALSE
14
PRODUCT A £ 183,702 13
FALSE
15
PRODUCT A £ 183,231 14
FALSE
16
PRODUCT A £ 179,651 15
FALSE
17
PRODUCT A £ 175,929 16
FALSE
18
PRODUCT A £ 155,360 17
FALSE
19
PRODUCT A £ 152,893 18
FALSE
20
PRODUCT A £ 127,054 19
FALSE
21
PRODUCT A £ 124,859 20
FALSE
22
PRODUCT B £ 116,724 18
FALSE
23
PRODUCT B £ 106,979 19
FALSE
24
PRODUCT B £ 89,422 1
TRUE
25
PRODUCT B £ 74,994 2
TRUE
26
PRODUCT B £ 73,020 3
TRUE
27
PRODUCT B £ 72,481 4
TRUE
28
PRODUCT B £ 65,808 5
TRUE
29
PRODUCT B £ 65,540 6
TRUE
30
PRODUCT B £ 60,228 7
TRUE
31
PRODUCT B £ 57,010 8
TRUE
32
PRODUCT B £ 56,915 9
TRUE
33
PRODUCT B £ 45,120 10
TRUE
34
PRODUCT B £ 40,169 11
FALSE
35
PRODUCT B £ 32,320 12
FALSE
36
PRODUCT B £ 31,973 13
FALSE
37
PRODUCT B £ 31,502 14
FALSE
38
PRODUCT B £ 29,754 15
FALSE
39
PRODUCT B £ 27,215 16
FALSE
40
PRODUCT B £ 27,208 17
FALSE
41
PRODUCT C £ 24,680 9
TRUE
42
PRODUCT C £ 23,973 10
TRUE
43
PRODUCT C £ 22,342 11
FALSE
44
PRODUCT C £ 19,884 14
FALSE
45
PRODUCT C £ 19,060 15
FALSE
46
PRODUCT C £ 17,835 16
FALSE
47
PRODUCT C £ 14,913 17
FALSE
48
PRODUCT C £ 14,649 18
FALSE
49
PRODUCT C £ 13,778 19
FALSE
50
PRODUCT C £ 13,179 20
FALSE
51
PRODUCT C £ 12,318 21
FALSE
52
PRODUCT C £ 11,798 22
FALSE
53
PRODUCT C £ 9,469 1
TRUE
54
PRODUCT C £ 9,331 2
TRUE
55
PRODUCT C £ 8,157 3
TRUE
56
PRODUCT C £ 7,258 4
TRUE
57
PRODUCT C £ 6,676 5
TRUE
58
PRODUCT C £ 5,417 6
TRUE
59
PRODUCT C £ 4,034 7
TRUE
60
PRODUCT C £ 3,160 8
TRUE
61
PRODUCT C £ 2,817 12
FALSE
62
PRODUCT C £ 2,625 13
FALSE
Sort that by Top 10 (Large > Small), Product (A-Z), and Rank (Small > Large) to see
Product
Sales
Rank
Top 10
PRODUCT A £ 584,794 1
TRUE
PRODUCT A £ 388,073 2
TRUE
PRODUCT A £ 383,689 3
TRUE
PRODUCT A £ 342,863 4
TRUE
PRODUCT A £ 336,309 5
TRUE
PRODUCT A £ 307,654 6
TRUE
PRODUCT A £ 259,484 7
TRUE
PRODUCT A £ 225,525 8
TRUE
PRODUCT A £ 221,328 9
TRUE
PRODUCT A £ 220,059 10
TRUE
PRODUCT B £ 89,422 1
TRUE
PRODUCT B £ 74,994 2
TRUE
PRODUCT B £ 73,020 3
TRUE
PRODUCT B £ 72,481 4
TRUE
PRODUCT B £ 65,808 5
TRUE
PRODUCT B £ 65,540 6
TRUE
PRODUCT B £ 60,228 7
TRUE
PRODUCT B £ 57,010 8
TRUE
PRODUCT B £ 56,915 9
TRUE
PRODUCT B £ 45,120 10
TRUE
PRODUCT C £ 9,469 1
TRUE
PRODUCT C £ 9,331 2
TRUE
PRODUCT C £ 8,157 3
TRUE
PRODUCT C £ 7,258 4
TRUE
PRODUCT C £ 6,676 5
TRUE
PRODUCT C £ 5,417 6
TRUE
PRODUCT C £ 4,034 7
TRUE
PRODUCT C £ 3,160 8
TRUE
PRODUCT C £ 24,680 9
TRUE
PRODUCT C £ 23,973 10
TRUE
PRODUCT A £ 197,443 11
FALSE
PRODUCT A £ 195,582 12
FALSE
PRODUCT A £ 183,702 13
FALSE
PRODUCT A £ 183,231 14
FALSE
PRODUCT A £ 179,651 15
FALSE
PRODUCT A £ 175,929 16
FALSE
PRODUCT A £ 155,360 17
FALSE
PRODUCT A £ 152,893 18
FALSE
PRODUCT A £ 127,054 19
FALSE
PRODUCT A £ 124,859 20
FALSE
PRODUCT B £ 40,169 11
FALSE
PRODUCT B £ 32,320 12
FALSE
PRODUCT B £ 31,973 13
FALSE
PRODUCT B £ 31,502 14
FALSE
PRODUCT B £ 29,754 15
FALSE
PRODUCT B £ 27,215 16
FALSE
PRODUCT B £ 27,208 17
FALSE
PRODUCT B £ 116,724 18
FALSE
PRODUCT B £ 106,979 19
FALSE
PRODUCT C £ 22,342 11
FALSE
PRODUCT C £ 2,817 12
FALSE
PRODUCT C £ 2,625 13
FALSE
PRODUCT C £ 19,884 14
FALSE
PRODUCT C £ 19,060 15
FALSE
PRODUCT C £ 17,835 16
FALSE
PRODUCT C £ 14,913 17
FALSE
PRODUCT C £ 14,649 18
FALSE
PRODUCT C £ 13,778 19
FALSE
PRODUCT C £ 13,179 20
FALSE
PRODUCT C £ 12,318 21
FALSE
PRODUCT C £ 11,798 22
FALSE
Threads
1,215,054
Messages
6,122,901
Members
449,097
Latest member
dbomb1414
