Minx_Minxy
New Member
- Joined
- Jul 13, 2015
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
Hello,
I really have no idea where to start and not even sure if this is available in excel.
I have a count of payments per branch, this is split into months. Now, I want to identify the top 10 branches with the highest count but also with the most frequency. For example, I know that Branches 2, 4, 5 and 9 should not be in the top 10 because the payments are not occurring as often.
Appreciate the input in advance
Regards,
I really have no idea where to start and not even sure if this is available in excel.
I have a count of payments per branch, this is split into months. Now, I want to identify the top 10 branches with the highest count but also with the most frequency. For example, I know that Branches 2, 4, 5 and 9 should not be in the top 10 because the payments are not occurring as often.
Appreciate the input in advance
Regards,
Query.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
2 | COUNT Per Month | Top 10 Count | ||||||||
3 | Branch Name | Month | COUNTA of Branch Name | Branch Name | Count | |||||
4 | Branch 1 | 01 Jan | 2 | |||||||
5 | 02 Feb | 2 | ||||||||
6 | 03 Mar | 10 | ||||||||
7 | 04 Apr | 5 | ||||||||
8 | 05 May | 2 | ||||||||
9 | 06 Jun | 6 | ||||||||
10 | 07 Jul | 8 | ||||||||
11 | 08 Aug | 1 | ||||||||
12 | 09 Sep | 6 | ||||||||
13 | 10 Oct | 6 | ||||||||
14 | 11 Nov | 15 | ||||||||
15 | 12 Dec | 4 | ||||||||
16 | Branch 1 Total | 67 | ||||||||
17 | Branch 2 | 01 Jan | 35 | |||||||
18 | 05 May | 6 | ||||||||
19 | 07 Jul | 6 | ||||||||
20 | 09 Sep | 2 | ||||||||
21 | Branch 2 Total | 49 | ||||||||
22 | Branch 3 | 05 May | 1 | |||||||
23 | 06 Jun | 1 | ||||||||
24 | 08 Aug | 8 | ||||||||
25 | 09 Sep | 4 | ||||||||
26 | 10 Oct | 6 | ||||||||
27 | 11 Nov | 17 | ||||||||
28 | 12 Dec | 4 | ||||||||
29 | Branch 3 Total | 41 | ||||||||
30 | Branch 4 | 03 Mar | 36 | |||||||
31 | 09 Sep | 1 | ||||||||
32 | 12 Dec | 1 | ||||||||
33 | Branch 4 Total | 38 | ||||||||
34 | Branch 5 | 07 Jul | 31 | |||||||
35 | 09 Sep | 1 | ||||||||
36 | 11 Nov | 1 | ||||||||
37 | 12 Dec | 3 | ||||||||
38 | Branch 5 Total | 36 | ||||||||
39 | Branch 6 | 01 Jan | 2 | |||||||
40 | 02 Feb | 1 | ||||||||
41 | 03 Mar | 2 | ||||||||
42 | 05 May | 1 | ||||||||
43 | 06 Jun | 2 | ||||||||
44 | 07 Jul | 4 | ||||||||
45 | 08 Aug | 2 | ||||||||
46 | 09 Sep | 7 | ||||||||
47 | 10 Oct | 11 | ||||||||
48 | 12 Dec | 1 | ||||||||
49 | Branch 6 Total | 33 | ||||||||
50 | Branch 7 | 01 Jan | 2 | |||||||
51 | 03 Mar | 11 | ||||||||
52 | 04 Apr | 1 | ||||||||
53 | 06 Jun | 1 | ||||||||
54 | 07 Jul | 3 | ||||||||
55 | 10 Oct | 3 | ||||||||
56 | 11 Nov | 4 | ||||||||
57 | 12 Dec | 8 | ||||||||
58 | Branch 7 Total | 33 | ||||||||
59 | Branch 8 | 01 Jan | 2 | |||||||
60 | 02 Feb | 2 | ||||||||
61 | 03 Mar | 24 | ||||||||
62 | 05 May | 1 | ||||||||
63 | 07 Jul | 3 | ||||||||
64 | Branch 8 Total | 32 | ||||||||
65 | Branch 9 | 02 Feb | 15 | |||||||
66 | 03 Mar | 14 | ||||||||
67 | Branch 9 Total | 29 | ||||||||
68 | Branch 10 | 02 Feb | 2 | |||||||
69 | 03 Mar | 5 | ||||||||
70 | 07 Jul | 4 | ||||||||
71 | 09 Sep | 3 | ||||||||
72 | 10 Oct | 10 | ||||||||
73 | 11 Nov | 1 | ||||||||
74 | 12 Dec | 1 | ||||||||
75 | Branch 10 Total | 26 | ||||||||
76 | Branch 11 | 02 Feb | 1 | |||||||
77 | 03 Mar | 20 | ||||||||
78 | 09 Sep | 3 | ||||||||
79 | Branch 11 Total | 24 | ||||||||
80 | Branch 12 | 01 Jan | 9 | |||||||
81 | 02 Feb | 1 | ||||||||
82 | 03 Mar | 2 | ||||||||
83 | 04 Apr | 3 | ||||||||
84 | 09 Sep | 4 | ||||||||
85 | 11 Nov | 2 | ||||||||
86 | 12 Dec | 1 | ||||||||
87 | Branch 12 Total | 22 | ||||||||
88 | Branch 13 | 01 Jan | 4 | |||||||
89 | 02 Feb | 2 | ||||||||
90 | 03 Mar | 4 | ||||||||
91 | 04 Apr | 1 | ||||||||
92 | 05 May | 3 | ||||||||
93 | 08 Aug | 2 | ||||||||
94 | 10 Oct | 1 | ||||||||
95 | 11 Nov | 5 | ||||||||
96 | Branch 13 Total | 22 | ||||||||
97 | Branch 14 | 01 Jan | 1 | |||||||
98 | 02 Feb | 4 | ||||||||
99 | 03 Mar | 8 | ||||||||
100 | 04 Apr | 1 | ||||||||
101 | 05 May | 2 | ||||||||
102 | 10 Oct | 3 | ||||||||
103 | 11 Nov | 1 | ||||||||
104 | 12 Dec | 2 | ||||||||
105 | Branch 14 Total | 22 | ||||||||
106 | Branch 15 | 12 Dec | 20 | |||||||
107 | Branch 15 Total | 20 | ||||||||
108 | Branch 16 | 01 Jan | 13 | |||||||
109 | 03 Mar | 5 | ||||||||
110 | 04 Apr | 2 | ||||||||
111 | Branch 16 Total | 20 | ||||||||
112 | Branch 17 | 03 Mar | 14 | |||||||
113 | 04 Apr | 1 | ||||||||
114 | 09 Sep | 2 | ||||||||
115 | 10 Oct | 1 | ||||||||
116 | 12 Dec | 1 | ||||||||
117 | Branch 17 Total | 19 | ||||||||
118 | Branch 18 | 03 Mar | 1 | |||||||
119 | 04 Apr | 2 | ||||||||
120 | 05 May | 1 | ||||||||
121 | 06 Jun | 1 | ||||||||
122 | 07 Jul | 1 | ||||||||
123 | 09 Sep | 11 | ||||||||
124 | 10 Oct | 1 | ||||||||
125 | Branch 18 Total | 18 | ||||||||
126 | Branch 20 | 01 Jan | 1 | |||||||
127 | 03 Mar | 10 | ||||||||
128 | 06 Jun | 2 | ||||||||
129 | 08 Aug | 4 | ||||||||
130 | Branch 20 Total | 17 | ||||||||
131 | Branch 21 | 08 Aug | 2 | |||||||
132 | 09 Sep | 3 | ||||||||
133 | 10 Oct | 10 | ||||||||
134 | 12 Dec | 1 | ||||||||
135 | Branch 21 Total | 16 | ||||||||
Sheet1 |