Sourdough123
Board Regular
- Joined
- Oct 25, 2021
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
Book1 | ||||||
---|---|---|---|---|---|---|
BS | BT | BU | BV | |||
49 | Customer | Sales | Sqm | Rep | ||
50 | Neil Laubcher | 94,107.00 | 12.97 | Steffan | ||
51 | Solid Ground | 24,691.12 | 6.92 | Tanja | ||
52 | Spotlight | 132,649.85 | 12.55 | Aretha | ||
53 | SMM | 10,845.00 | 3.09 | Steffan | ||
54 | Alto Kitchens | 3,248.23 | 1.82 | Tanja | ||
55 | Alto Kitchens | 3,248.23 | 1.68 | Tanja | ||
56 | Spotlight Joinery | 1,780.55 | 0.54 | Aretha | ||
57 | Spotlight Joinery | 6,721.02 | 1.77 | Aretha | ||
58 | Spotlight Joinery | 4,361.95 | 1.4 | Aretha | ||
59 | Elk Stb | 3,469.00 | 0.85 | Aretha | ||
60 | Sota Joinery | 5,310.15 | 1.33 | Aretha | ||
61 | Top Living | 24,292.08 | 8.55 | Tanja | ||
62 | KITCHES 4 LIFE | 3,046.18 | 0.96 | Aretha | ||
63 | Elk | 10,348.08 | 2.06 | Aretha | ||
64 | Ellen Berry | 2,584.80 | 1.33 | Tanja | ||
65 | Solus Designs | 9,407.00 | 1.34 | Steffan | ||
66 | Core Interiors | 20,897.00 | 2.54 | Steffan | ||
67 | Craig Suanderson | 31,525.01 | 9.96 | Aretha | ||
68 | STELBOU | 11,766.00 | 2.56 | Aretha | ||
69 | Elk Tableview | 16,898.00 | 4.17 | Steffan | ||
70 | Shahid | 12,848.00 | 3.89 | Steffan | ||
71 | Brick N Board | 16,867.40 | 8.22 | Tanja | ||
72 | MSP | 10,985.00 | 3.34 | Aretha | ||
73 | Aristo | 50,664.00 | 15.08 | Steffan | ||
74 | Tara Decon | 7,179.53 | 2.25 | Aretha | ||
75 | My Kitchen Co | 8,027.88 | 2.18 | Aretha | ||
76 | Echo Kitchens | 25,001.38 | 6.6 | Aretha | ||
77 | Sota Joinery | 7,934.51 | 2.48 | Aretha | ||
78 | Elk Tableview | 10,840.00 | 0.76 | Steffan | ||
79 | Top Living | 24,291.08 | 8.5 | Tanja | ||
80 | Top Living | 15,440.13 | 5.94 | Tanja | ||
81 | Top Living | 15,440.13 | 6.03 | Tanja | ||
82 | MSP | 25,663.51 | 7.78 | Aretha | ||
83 | Cami Interiors | 33,992.00 | 3.48 | Steffan | ||
84 | MSM | 5,729.29 | 1 | Aretha | ||
85 | Elk | 14,254.63 | 3.69 | Aretha | ||
86 | Craig Suanderson | 12,089.00 | 3.5 | Aretha | ||
87 | Interior Fusion | 23,373.00 | 5.37 | Steffan | ||
88 | Keith Vroom | 15,866.00 | 1.32 | STEFFAN | ||
89 | MSP | 8,077.00 | 2.1 | Aretha | ||
90 | MSP | 8,031.00 | 2.09 | Aretha | ||
91 | MSP | 7,889.00 | 2.04 | ARETHA | ||
92 | MSP | 7,909.00 | 2.05 | ARETHA | ||
93 | Paxton Kitchens | 3,416.00 | 1.07 | ARETHA | ||
94 | Brick N Board | 6,888.00 | 3.25 | Tanja | ||
95 | Brick N Board | 6,888.00 | 3.25 | Tanja | ||
96 | Brick N Board | 6,888.00 | 3.24 | Tanja | ||
97 | Brick N Board | 6,888.00 | 3.34 | Tanja | ||
98 | Corne Du Toit | 2,171.00 | 0.74 | STEFFAN | ||
99 | Kurts Kitchens | 19,532.00 | 7.12 | Aretha | ||
100 | Urban Projects | 5,538.00 | 1.43 | Steffan | ||
101 | Urban Projects | 2,039.00 | 0.55 | STEFFAN | ||
102 | Maruis Barhyssen | 29,954.00 | 3.08 | Tanja | ||
103 | Craig Suanderson | 58,985.00 | 19.06 | Aretha | ||
104 | Brick N Board | 6,888.00 | 3.29 | Tanja | ||
105 | Brick N Board | 6,888.00 | 3.34 | Tanja | ||
106 | Brick N Board | 6,888.00 | 3.34 | Tanja | ||
107 | Milyka | 37,543.68 | 10.83 | Aretha | ||
108 | Elk Paarl | 2,898.70 | 1.02 | Aretha | ||
109 | Sota Joinery | 11,853.11 | 2.83 | Aretha | ||
110 | Black Wood Shopfitting | 92,862.00 | 9.2 | Steffan | ||
111 | Black Wood Shopfitting | 24,589.00 | 6.99 | Steffan | ||
112 | Ian Hardman | 4,730.00 | 3.39 | Steffan | ||
113 | Spotlight | 91,690.71 | 18.45 | Aretha | ||
114 | Milyka | 15,625.00 | 4.92 | Aretha | ||
115 | Fine Craft Cpt | 13,327.40 | 3.19 | Aretha | ||
116 | Crystal And Crumb | 35,919.00 | 8.24 | Steffan | ||
117 | Spotlight | 34,236.00 | 4.44 | Aretha | ||
118 | WD Construction | 19,004.00 | 6.14 | Steffan | ||
119 | Milyka | 63,348.71 | 16.66 | Aretha | ||
120 | Top Living | 15,440.13 | 5.99 | Aretha | ||
121 | Top Living | 15,440.13 | 5.89 | Tanja | ||
122 | Top Living | 22,044.83 | 8.5 | Tanja | ||
123 | MSP | 24,324.00 | 8.49 | Aretha | ||
124 | Elk Paarl | 8,154.00 | 2.7 | Aretha | ||
125 | Elk Paarl | 8,154.00 | 0 | Aretha | ||
126 | Designed By Louis | 30,709.49 | 9.49 | Aretha | ||
127 | Edge Arch | 60,599.44 | 9.9 | Aretha | ||
128 | MSP | 9,617.30 | 3.14 | Aretha | ||
129 | MSP | 9,679.44 | 3.16 | Aretha | ||
130 | AE Kaste | 53,314.73 | 12.33 | Aretha | ||
131 | Brick N Board | 7,464.75 | 3.81 | Tanja | ||
132 | Cami Interiors | 54,173.00 | 14.55 | Steffan | ||
133 | Black Wood Shopfitting | 14,910.00 | 6.1 | Steffan | ||
134 | Brick N Board | 7,464.75 | 3.81 | Tanja | ||
135 | Brick N Board | 6,888.00 | 3.37 | Tanja | ||
136 | Brick N Board | 6,888.00 | 3.37 | Tanja | ||
137 | Revolution Shopfitters | 17,618.00 | 4.71 | Steffan | ||
138 | MSP | 20,681.00 | 5.35 | Aretha | ||
139 | AE Kaste | 1,528.00 | 0.16 | ARETHA | ||
140 | R+N Master Builders | 1,990.00 | 0.93 | ARETHA | ||
141 | Echo Kitchens | 6,476.00 | 2.03 | ARETHA | ||
142 | Brick N Board | 5,997.00 | 3.39 | Tanja | ||
143 | Brick N Board | 5,997.00 | 3.39 | TANJA | ||
144 | Brick N Board | 5,997.00 | 3.38 | TANJA | ||
145 | MSP | 11,701.00 | 3.14 | Aretha | ||
146 | Brick N Board | 5,997.00 | 3.37 | Tanja | ||
147 | Brick N Board | 6,888.00 | 3.39 | Tanja | ||
148 | Brick N Board | 6,888.00 | 3.3 | Tanja | ||
149 | Sublime Cupboards | 12,780.00 | 4.32 | Aretha | ||
150 | Hannes Malan | 18,210.00 | 5.48 | Henk | ||
151 | Interior Fusion | 18,092.00 | 5.69 | Steffan | ||
152 | Brick N Board | 6,888.00 | 3.36 | Tanja | ||
153 | Quantum Leap | 2,392.00 | 0.75 | ARETHA | ||
154 | Euro Cassa | 109,579.00 | 14.49 | Steffan | ||
155 | Euro Cassa | 16,456.00 | 1.16 | Steffan | ||
156 | MSM | 29,125.00 | 13.32 | Aretha | ||
157 | Libra | 9,418.00 | 1.86 | Steffan | ||
158 | MSP | 4,005.00 | 1.16 | ARETHA | ||
159 | Milyka | 55,624.00 | 14.6 | Aretha | ||
160 | Midcape Construction | 24,940.00 | 8.44 | Steffan | ||
161 | Brick N Board | 22,821.00 | 6.22 | Tanja | ||
162 | Core Interiors | 53,461.00 | 10.32 | Steffan | ||
163 | Edge Arch | 6,261.00 | 2.879 | Aretha | ||
164 | Elk SSW | 12,674.00 | 2.98 | Aretha | ||
165 | Country Style | 24,140.00 | 11.01 | Henk | ||
166 | BRILLIANT HOME DESIGN | 10,825.00 | 2.97 | Aretha | ||
167 | Interior Fusion | 7,306.00 | 2.02 | STEFFAN | ||
168 | Brick N Board | 8,256.00 | 3.82 | Tanja | ||
169 | Brick N Board | 12,635.00 | 5.63 | Tanja | ||
170 | Conradie Kaste | 47,941.00 | 10.92 | Steffan | ||
171 | Aristo | 21,747.00 | 5.4 | Steffan | ||
172 | Superior Cabinets | 115,509.00 | 38.9 | Steffan | ||
173 | Top Living | 24,291.00 | 8.88 | Tanja | ||
174 | Top Living | 24,291.00 | 8.87 | Tanja | ||
175 | CCMI | 9,399.00 | 2.15 | STEFFAN | ||
176 | Brick N Board | 15,440.00 | 3.82 | Tanja | ||
177 | Crontec | 10,574.00 | 2.92 | STEFFAN | ||
178 | Spotlight | 15,165.00 | 1.47 | Aretha | ||
179 | MSP | 5,448.00 | 1.66 | Aretha | ||
180 | Spotlight | 68,604.00 | 16.33 | Aretha | ||
181 | Spotlight | 42,109.00 | 6.19 | Aretha | ||
182 | Spotlight | 62,395.00 | 15.6 | Aretha | ||
183 | Spotlight | 86,118.00 | 4.9 | Aretha | ||
184 | Big Ben | 3,806.00 | 1.73 | Tanja | ||
185 | Big Ben | 3,825.00 | 1.74 | Tanja | ||
186 | Big Ben | 5,366.00 | 2.445 | TANJA | ||
187 | Big Ben | 4,925.00 | 2.24 | TANJA | ||
188 | Kitch Me Up | 12,264.00 | 4.1 | Aretha | ||
189 | Big Ben | 4,134.00 | 2.07 | Tanja | ||
190 | Big Ben | 6,271.00 | 2.93 | Tanja | ||
191 | Top Living | 6,938.00 | 2.53 | TANJA | ||
192 | Dng Interiors | 30,405.00 | 10.42 | Steffan | ||
193 | Echo Kitchens | 2,137.00 | 0.61 | ARETHA | ||
194 | My Kitchen Co | 4,266.00 | 1.06 | ARETHA | ||
195 | VICTOR | 1,365.00 | 0.46 | ARETHA | ||
196 | Crontec | 45,610.00 | 17.656 | Steffan | ||
197 | Brick N Board | 5,997.00 | 3.386 | Tanja | ||
198 | Brick N Board | 5,325.00 | 3.51 | TANJA | ||
199 | Colcab | 51,364.00 | 4.58 | HENK | ||
200 | Colcab | 51,365.00 | 4.58 | HENK | ||
201 | Brick N Board | 6,888.00 | 3.29 | Tanja | ||
202 | Brick N Board | 7,699.00 | 3.78 | Tanja | ||
203 | Crontec | 14,958.00 | 9.22 | Steffan | ||
204 | Elk SSW | 24,373.00 | 6 | Aretha | ||
205 | MSP | 23,700.00 | 6.53 | Aretha | ||
206 | MSP | 18,780.00 | 4.89 | Aretha | ||
207 | Elk Tableview | 1.00 | 4.73 | Steffan | ||
208 | Top Living | 24,291.00 | 8.37 | Tanja | ||
209 | Top Living | 15,440.00 | 5.97 | Tanja | ||
210 | BENCHMARK | 16,692.00 | 1.14 | Steffan | ||
211 | USED | 3.00 | 3.87 | Henk | ||
212 | Interior Fusion | 44,726.00 | 9.39 | Steffan | ||
213 | Elk Hermanus | 63,390.00 | 10.56 | Aretha | ||
214 | REGAL CONCEPTS | 10,236.00 | 2.93 | Steffan | ||
215 | MSP | 19,300.00 | 5.05 | Aretha | ||
216 | MSP | 24,324.00 | 6.39 | Aretha | ||
217 | MSP | 12,103.00 | 3.18 | ARETHA | ||
218 | Elk Hermanus | 7,539.00 | 2.2 | Aretha | ||
219 | MSP | 9,116.00 | 2.54 | Aretha | ||
220 | MSP | 11,170.00 | 3.14 | Aretha | ||
221 | MSP | 11,253.00 | 3.16 | Aretha | ||
222 | MSP | 11,220.00 | 3.15 | Aretha | ||
223 | MSP | 7,704.00 | 1.98 | Aretha | ||
224 | MSP | 7,644.00 | 1.98 | Aretha | ||
225 | MSP | 9,645.00 | 2.63 | ARETHA | ||
226 | Sota Joinery | 20,719.00 | 4.91 | Aretha | ||
227 | Designed By Louis | 20,107.00 | 6.38 | Aretha | ||
228 | Brick N Board | 5,997.00 | 3.34 | Tanja | ||
229 | Top Living | 15,440.00 | 5.99 | Tanja | ||
230 | Top Living | 24,291.00 | 8.45 | Tanja | ||
231 | Brick N Board | 5,997.00 | 3.3 | Tanja | ||
232 | Aristo | 24,360.00 | 3.2 | Steffan | ||
233 | Alto Kitchens | 5,820.00 | 2.97 | Tanja | ||
234 | Brick N Board | 6,888.00 | 3.3 | Tanja | ||
235 | Alto Kitchens | 5,820.00 | 2.99 | Tanja | ||
236 | Brick N Board | 6,888.00 | 3.35 | Tanja | ||
237 | Alto Kitchens | 5,820.00 | 3.01 | Tanja | ||
238 | Alto Kitchens | 5,820.00 | 2.98 | Tanja | ||
239 | Alto Kitchens | 5,820.00 | 2.99 | Tanja | ||
240 | Brick N Board | 6,888.00 | 3.34 | Tanja | ||
241 | Alto Kitchens | 5,820.00 | 2.97 | Tanja | ||
242 | Alto Kitchens | 5,820.00 | 3.01 | Tanja | ||
243 | CCMI | 41,871.00 | 7.57 | Steffan | ||
244 | MSP | 11,247.00 | 3.26 | Aretha | ||
245 | Cami Interiors | 85,466.00 | 10.02 | Steffan | ||
246 | CCMI | 9,407.00 | 2.7 | Steffan | ||
247 | Brick N Board | 6,888.00 | 3.34 | Tanja | ||
248 | Alto Kitchens | 5,820.00 | 2.99 | Tanja | ||
249 | Alto Kitchens | 5,820.00 | 3.01 | Tanja | ||
250 | Alto Kitchens | 5,820.00 | 2.98 | Tanja | ||
251 | Alto Kitchens | 5,820.00 | 2.98 | Tanja | ||
252 | Alto Kitchens | 5,820.00 | 2.99 | Tanja | ||
253 | Designed By Louis | 19,298.00 | 2.24 | Aretha | ||
254 | Designed By Louis | 10,783.00 | 2.66 | Aretha | ||
255 | Brick N Board | 6,888.00 | 3.34 | Tanja | ||
256 | Brick N Board | 6,888.00 | 3.32 | Tanja | ||
257 | Brick N Board | 6,888.00 | 3.33 | Tanja | ||
258 | Frans Prinsloo | 2,103.00 | 0.38 | Steffan | ||
259 | MSP | 14,430.00 | 4.85 | Aretha | ||
260 | MSP | 9,876.00 | 2.8 | Aretha | ||
261 | 76 Build | 95,163.00 | 13.54 | Aretha | ||
262 | Solid Ground | 18,842.00 | 5.82 | Tanja | ||
263 | Top Living | 15,440.00 | 5.94 | Tanja | ||
264 | NOORDHOEK HOTEL | 13,051.00 | 3.64 | Aretha | ||
265 | MSP | 7,918.00 | 2.05 | Aretha | ||
266 | MSP | 7,927.00 | 2.06 | Aretha | ||
267 | MSP | 7,918.00 | 2.06 | ARETHA | ||
268 | MSP | 7,930.00 | 2.04 | ARETHA | ||
269 | Solid Ground | 8,670.00 | 2.71 | Tanja | ||
270 | Big Ben | 5,360.00 | 2.44 | Tanja | ||
271 | Big Ben | 5,340.00 | 2.43 | TANJA | ||
272 | Big Ben | 4,616.00 | 2.44 | TANJA | ||
273 | Alto Kitchens | 5,820.00 | 2.97 | Tanja | ||
274 | Alto Kitchens | 5,820.00 | 2.99 | Tanja | ||
275 | Big Ben | 4,621.00 | 2.44 | TANJA | ||
276 | Big Ben | 4,616.00 | 2.44 | Tanja | ||
277 | Big Ben | 4,621.00 | 2.44 | Tanja | ||
278 | Elk Hermanus | 29,648.00 | 7.72 | Aretha | ||
279 | Collaboration | 37,800.00 | 4.89 | Henk | ||
280 | OOOH INTERIORS | 39,919.00 | 6.63 | Aretha | ||
281 | Spotlight | 11,081.00 | 0.58 | Aretha | ||
282 | OOOH INTERIORS | 26,414.00 | 2.42 | Aretha | ||
283 | Brick N Board | 6,888.00 | 3.4 | Tanja | ||
284 | Revolution Shopfitters | 2,313.00 | 0.89 | STEFFAN | ||
285 | Elk SSW | 67,829.00 | 7.46 | Aretha | ||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
BS50:BS285 | Cell Value | contains "Conradie" | text | NO |
BS50:BS110 | Cell Value | contains "colcab" | text | NO |
BT50:BT222 | Cell Value | duplicates | text | NO |
I want to extract top 10 customers in value ....the names
This is my formula but i need a sum function in to add up all duplicate customers values
=UNIQUE(XLOOKUP(LARGE(IF($BV$50:$BV$3500=BL$73,$BT$50:$BT$3500),SEQUENCE(10)),$BT$50:$BT$3500,$BS$50:$BS$3500))
Can you give hand please
Good Morning