If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Reorder data

Thread starter nastyveg
Start date Nov 24, 2022

N

nastyveg

New Member

Nov 24, 2022

#1

Hi, I need to reorder the attached data. Using columns Brochure Type 1 | Brochure Type 2 | Brochure Type 3
I need it to be ordered
B Only
S Only
H Only
S | H
B | Any other
Is this even possible?

Thanks

ID	Brochure Type 1	Brochure Type 2	Brochure Type 3	Entry Date	Sent
1			S	22/11/2022 09:33	No	0.28
2			S	22/11/2022 09:41	No	0.28
3	B	S		22/11/2022 09:42	No	0.33
4	H			22/11/2022 09:48	No	0.28
5	B	S		22/11/2022 09:56	No	0.33
6	B	H		22/11/2022 09:59	No	0.33
7	B	S		22/11/2022 10:17	No	0.33
8	B			22/11/2022 10:26	No	0.28
9	S			22/11/2022 10:29	No	0.28
10	B	H		22/11/2022 10:35	No	0.33
11	S			22/11/2022 10:40	No	0.28
12			S	22/11/2022 10:41	No	0.28
13	B	S		22/11/2022 10:45	No	0.33
14	B			22/11/2022 10:47	No	0.28
15			S	22/11/2022 10:58	No	0.28
16	B	H		22/11/2022 11:04	No	0.33
17	B			22/11/2022 11:31	No	0.28
18	B	S		22/11/2022 11:39	No	0.33
19	S			22/11/2022 11:39	No	0.28
20	B	S		22/11/2022 11:48	No	0.33
21			S	22/11/2022 11:49	No	0.28
22	B	S		22/11/2022 11:53	No	0.33
23			S	22/11/2022 11:54	No	0.28
24	B	H		22/11/2022 11:55	No	0.33
25	B	H		22/11/2022 11:59	No	0.33
26			S	22/11/2022 12:09	No	0.28
27			S	22/11/2022 12:16	No	0.28
28			B	22/11/2022 12:24	No	0.28
29			S	22/11/2022 12:26	No	0.28
30	B	S		22/11/2022 12:30	No	0.33
31	B	H		22/11/2022 12:39	No	0.33
32			B	22/11/2022 12:42	No	0.28
33			S	22/11/2022 12:45	No	0.28
34			B	22/11/2022 12:49	No	0.28
35			B	22/11/2022 12:53	No	0.28
36			B	22/11/2022 12:56	No	0.28
37			S	22/11/2022 13:03	No	0.28
38	B			22/11/2022 13:14	No	0.28
39	B	S		22/11/2022 13:21	No	0.33
40	S			22/11/2022 13:35	No	0.28
41			S	22/11/2022 13:35	No	0.28
42	B			22/11/2022 13:35	No	0.28
43			S	22/11/2022 13:40	No	0.28
44	B	H		22/11/2022 13:40	No	0.33
45	B	S		22/11/2022 13:53	No	0.33
46			S	22/11/2022 13:58	No	0.28
47	B			22/11/2022 14:01	No	0.28
48	H			22/11/2022 14:08	No	0.28
49			S	22/11/2022 14:17	No	0.28
50	B			22/11/2022 14:18	No	0.28
51	B			22/11/2022 14:19	No	0.28
52			S	22/11/2022 14:23	No	0.28
53	B	S		22/11/2022 14:25	No	0.33
54	S			22/11/2022 14:41	No	0.28
55	B			22/11/2022 14:50	No	0.28
56			S	22/11/2022 14:50	No	0.28
57	B			22/11/2022 15:23	No	0.28
58			S	22/11/2022 15:24	No	0.28
59	H			22/11/2022 15:47	No	0.28
60			S	22/11/2022 15:53	No	0.28
61			S	22/11/2022 15:59	No	0.28
62			S	22/11/2022 15:59	No	0.28
63			S	22/11/2022 16:01	No	0.28
64			S	22/11/2022 16:02	No	0.28
65	B	H		22/11/2022 16:24	No	0.33
66	B			22/11/2022 16:26	No	0.28
67	B			22/11/2022 16:29	No	0.28
68	B			22/11/2022 16:34	No	0.28
69	B			22/11/2022 16:47	No	0.28
70	B	S		22/11/2022 17:06	No	0.33
71	B	S		22/11/2022 17:32	No	0.33
72	H			22/11/2022 17:34	No	0.28
73	H			22/11/2022 17:40	No	0.28
74	B	S		22/11/2022 17:41	No	0.33
75	B	S		22/11/2022 17:52	No	0.33
76	B	S		22/11/2022 18:09	No	0.33
77	B			22/11/2022 19:07	No	0.28
78	B	H		22/11/2022 09:33	No	0.33
79	B	H		22/11/2022 09:41	No	0.33
80	B	H		22/11/2022 10:41	No	0.33
81	B	H		22/11/2022 10:58	No	0.33
82	B	H		22/11/2022 11:49	No	0.33
83	B	H		22/11/2022 11:54	No	0.33
84	B	H		22/11/2022 12:09	No	0.33
85	B	H		22/11/2022 12:16	No	0.33
86	S	H		22/11/2022 12:24	No	0.33
87	B	H		22/11/2022 12:26	No	0.33
88	S	H		22/11/2022 12:42	No	0.33
89	B	H		22/11/2022 12:45	No	0.33
90	S	H		22/11/2022 12:49	No	0.33
91	S	H		22/11/2022 12:53	No	0.33
92	S	H		22/11/2022 12:56	No	0.33
93	B	H		22/11/2022 13:03	No	0.33
94	B	H		22/11/2022 13:35	No	0.33
95	B	H		22/11/2022 13:40	No	0.33
96	B	H		22/11/2022 13:58	No	0.33
97	B	H		22/11/2022 14:17	No	0.33
98	B	H		22/11/2022 14:23	No	0.33
99	B	H		22/11/2022 14:50	No	0.33
100	B	H		22/11/2022 15:24	No	0.33
101	B	H		22/11/2022 15:53	No	0.33
102	B	H		22/11/2022 15:59	No	0.33
103	B	H		22/11/2022 15:59	No	0.33
104	B	H		22/11/2022 16:01	No	0.33
105	B	H		22/11/2022 16:02	No	0.33
106						32

Excel Facts

Convert text numbers to real numbers

Click here to reveal answer

Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Sort by date Sort by votes

L

Legacy 143009

Guest

Nov 24, 2022

#2

Ok, it is a bit clumsy solution but works :D
Make a new helper column. Paste this formula. Put filters on column headers. Sort new column from large to small.

Excel Formula:

=IF(AND(B2="B",OR(C2<>"",D2<>"")),A2*100,IF(B2&C2&D2="SH",A2*10000,IF(B2&C2&D2="H",A2*1000000,IF(B2&C2&D2="S",A2*100000000,IF(B2&C2&D2="B",A2*10000000000)))))

Upvote 0

N

nastyveg

New Member

Nov 24, 2022

#3

Hi @Flashbond, thanks for this.
I'm not sure I've done this correctly as the ID/Customer Number doesn't move.
I only supplied test fields, here it is with all fields included.
What we are doing is trying to sort by weight. B only = 500g, S or H = 300g, B + any other = 700g and S or H = 450g
So maybe that would be a better way of doing this? We are packing these but need to produce in a better order ie heaviest combo to lightest or vice versa.
I hope that makes sense?
Thanks again for your help.

Customer Number

Title

Firstname

Lastname

Add Line 1

Add Line 2

Add Line 3

City

Postcode

Broucher Type 1

Broucher Type 2

Broucher Type 3

Entry Date

3912759

Mr

A

Test

123

Road

City

AB1 2CD

B

S

23/11/2022 09:31

3912761

Mr

A

Test

124

Road

City

AB1 2CD

B

S

23/11/2022 09:31

3912735

Mr

A

Test

125

Road

City

AB1 2CD

H

23/11/2022 09:38

3912711

Mr

A

Test

126

Road

City

AB1 2CD

B

23/11/2022 09:45

3912760

Mr

A

Test

127

Road

City

AB1 2CD

B

S

23/11/2022 10:03

3912751

Mr

A

Test

128

Road

City

AB1 2CD

B

S

23/11/2022 10:03

3912723

Mr

A

Test

129

Road

City

AB1 2CD

B

S

23/11/2022 10:03

3646672

Mr

A

Test

130

Road

City

AB1 2CD

S

23/11/2022 10:12

3290757

Mr

A

Test

131

Road

City

AB1 2CD

S

23/11/2022 10:31

3702449

Mr

A

Test

132

Road

City

AB1 2CD

S

23/11/2022 10:35

3912780

Mr

A

Test

133

Road

City

AB1 2CD

B

23/11/2022 10:54

3446122

Mr

A

Test

134

Road

City

AB1 2CD

B

23/11/2022 10:58

3912508

Mr

A

Test

135

Road

City

AB1 2CD

H

23/11/2022 10:59

1727943

Mr

A

Test

136

Road

City

AB1 2CD

B

23/11/2022 11:10

2565052

Mr

A

Test

137

Road

City

AB1 2CD

B

23/11/2022 11:22

3906499

Mr

A

Test

138

Road

City

AB1 2CD

H

23/11/2022 11:25

3758947

Mr

A

Test

139

Road

City

AB1 2CD

B

23/11/2022 11:43

3912766

Mr

A

Test

140

Road

City

AB1 2CD

B

S

23/11/2022 12:01

3836182

Mr

A

Test

141

Road

City

AB1 2CD

B

23/11/2022 12:01

3912794

Mr

A

Test

142

Road

City

AB1 2CD

B

23/11/2022 12:02

3795124

Mr

A

Test

143

Road

City

AB1 2CD

S

23/11/2022 12:11

3912728

Mr

A

Test

144

Road

City

AB1 2CD

B

S

23/11/2022 12:13

3912687

Mr

A

Test

145

Road

City

AB1 2CD

B

S

23/11/2022 12:14

1881209

Mr

A

Test

146

Road

City

AB1 2CD

B

23/11/2022 12:22

3912799

Mr

A

Test

147

Road

City

AB1 2CD

B

23/11/2022 12:26

3912800

Mr

A

Test

148

Road

City

AB1 2CD

B

23/11/2022 12:28

3912807

Mr

A

Test

149

Road

City

AB1 2CD

B

23/11/2022 12:45

3912809

Mr

A

Test

150

Road

City

AB1 2CD

H

S

23/11/2022 12:47

1890905

Mr

A

Test

151

Road

City

AB1 2CD

B

23/11/2022 12:50

3912813

Mr

A

Test

152

Road

City

AB1 2CD

B

S

23/11/2022 13:31

3912796

Mr

A

Test

153

Road

City

AB1 2CD

B

S

23/11/2022 13:33

3912790

Mr

A

Test

154

Road

City

AB1 2CD

S

B

23/11/2022 13:35

3912742

Mr

A

Test

155

Road

City

AB1 2CD

H

23/11/2022 13:44

3912817

Mr

A

Test

156

Road

City

AB1 2CD

B

S

23/11/2022 13:49

3877788

Mr

A

Test

157

Road

City

AB1 2CD

H

S

23/11/2022 14:01

3912831

Mr

A

Test

158

Road

City

AB1 2CD

B

23/11/2022 14:13

3912833

Mr

A

Test

159

Road

City

AB1 2CD

B

23/11/2022 14:20

3910147

Mr

A

Test

160

Road

City

AB1 2CD

B

H

23/11/2022 14:34

3871246

Mr

A

Test

161

Road

City

AB1 2CD

B

23/11/2022 14:44

3912841

Mr

A

Test

162

Road

City

AB1 2CD

B

23/11/2022 14:53

3907278

Mr

A

Test

163

Road

City

AB1 2CD

B

23/11/2022 15:14

2395949

Mr

A

Test

164

Road

City

AB1 2CD

B

23/11/2022 15:59

3760542

Mr

A

Test

165

Road

City

AB1 2CD

B

23/11/2022 16:03

3912510

Mr

A

Test

166

Road

City

AB1 2CD

B

S

23/11/2022 16:09

3912851

Mr

A

Test

167

Road

City

AB1 2CD

B

S

23/11/2022 16:09

3912855

Mr

A

Test

168

Road

City

AB1 2CD

B

S

23/11/2022 17:01

3912864

Mr

A

Test

169

Road

City

AB1 2CD

B

23/11/2022 18:46

3912870

Mr

A

Test

170

Road

City

AB1 2CD

B

23/11/2022 19:11

3803408

Mr

A

Test

171

Road

City

AB1 2CD

S

H

23/11/2022 09:47

3912671

Mr

A

Test

172

Road

City

AB1 2CD

H

S

23/11/2022 09:53

3912762

Mr

A

Test

173

Road

City

AB1 2CD

H

S

23/11/2022 10:09

2856000

Mr

A

Test

174

Road

City

AB1 2CD

S

H

23/11/2022 10:16

3363023

Mr

A

Test

175

Road

City

AB1 2CD

S

H

23/11/2022 10:56

3044677

Mr

A

Test

176

Road

City

AB1 2CD

S

H

23/11/2022 10:57

1510066

Mr

A

Test

177

Road

City

AB1 2CD

S

H

23/11/2022 10:57

3572647

Mr

A

Test

178

Road

City

AB1 2CD

H

S

23/11/2022 10:58

3912720

Mr

A

Test

179

Road

City

AB1 2CD

H

S

23/11/2022 10:58

2786288

Mr

A

Test

180

Road

City

AB1 2CD

S

H

23/11/2022 10:58

3808234

Mr

A

Test

181

Road

City

AB1 2CD

H

S

23/11/2022 10:59

3459020

Mr

A

Test

182

Road

City

AB1 2CD

H

S

23/11/2022 10:59

3702122

Mr

A

Test

183

Road

City

AB1 2CD

H

S

23/11/2022 10:59

3682502

Mr

A

Test

184

Road

City

AB1 2CD

H

S

23/11/2022 10:59

3912785

Mr

A

Test

185

Road

City

AB1 2CD

H

S

23/11/2022 11:29

3912787

Mr

A

Test

186

Road

City

AB1 2CD

H

S

23/11/2022 11:39

3836709

Mr

A

Test

187

Road

City

AB1 2CD

H

S

23/11/2022 11:40

3912775

Mr

A

Test

188

Road

City

AB1 2CD

H

S

23/11/2022 11:40

2473190

Mr

A

Test

189

Road

City

AB1 2CD

S

H

23/11/2022 11:40

2617263

Mr

A

Test

190

Road

City

AB1 2CD

H

S

23/11/2022 11:41

3909356

Mr

A

Test

191

Road

City

AB1 2CD

H

S

23/11/2022 11:42

3837712

Mr

A

Test

192

Road

City

AB1 2CD

H

S

23/11/2022 11:43

3788169

Mr

A

Test

193

Road

City

AB1 2CD

H

S

23/11/2022 11:43

3779477

Mr

A

Test

194

Road

City

AB1 2CD

S

H

23/11/2022 11:43

3619551

Mr

A

Test

195

Road

City

AB1 2CD

H

S

23/11/2022 11:44

3257312

Mr

A

Test

196

Road

City

AB1 2CD

H

S

23/11/2022 11:44

3854434

Mr

A

Test

197

Road

City

AB1 2CD

S

H

23/11/2022 11:48

3712039

Mr

A

Test

198

Road

City

AB1 2CD

H

S

23/11/2022 11:48

3279487

Mr

A

Test

199

Road

City

AB1 2CD

H

S

23/11/2022 11:48

3101217

Mr

A

Test

200

Road

City

AB1 2CD

H

S

23/11/2022 11:49

3912756

Mr

A

Test

201

Road

City

AB1 2CD

H

S

23/11/2022 11:49

3250392

Mr

A

Test

202

Road

City

AB1 2CD

S

H

23/11/2022 11:50

2475141

Mr

A

Test

203

Road

City

AB1 2CD

H

S

23/11/2022 11:50

1927505

Mr

A

Test

204

Road

City

AB1 2CD

S

H

23/11/2022 11:50

1785249

Mr

A

Test

205

Road

City

AB1 2CD

H

S

23/11/2022 11:51

3912749

Mr

A

Test

206

Road

City

AB1 2CD

H

S

23/11/2022 11:51

3363388

Mr

A

Test

207

Road

City

AB1 2CD

H

S

23/11/2022 11:51

3912788

Mr

A

Test

208

Road

City

AB1 2CD

H

S

23/11/2022 11:56

3912792

Mr

A

Test

209

Road

City

AB1 2CD

H

S

23/11/2022 11:57

3016864

Mr

A

Test

210

Road

City

AB1 2CD

H

S

23/11/2022 11:58

3911730

Mr

A

Test

211

Road

City

AB1 2CD

H

S

23/11/2022 12:00

3912776

Mr

A

Test

212

Road

City

AB1 2CD

H

S

23/11/2022 12:00

3612458

Mr

A

Test

213

Road

City

AB1 2CD

H

S

23/11/2022 12:00

2581391

Mr

A

Test

214

Road

City

AB1 2CD

H

S

23/11/2022 12:00

3912769

Mr

A

Test

215

Road

City

AB1 2CD

H

S

23/11/2022 12:01

3912791

Mr

A

Test

216

Road

City

AB1 2CD

H

S

23/11/2022 12:01

3912793

Mr

A

Test

217

Road

City

AB1 2CD

H

S

23/11/2022 12:01

3729801

Mr

A

Test

218

Road

City

AB1 2CD

H

S

23/11/2022 12:05

3912781

Mr

A

Test

219

Road

City

AB1 2CD

H

S

23/11/2022 12:05

3739761

Mr

A

Test

220

Road

City

AB1 2CD

H

S

23/11/2022 12:06

3912795

Mr

A

Test

221

Road

City

AB1 2CD

H

S

23/11/2022 12:07

3817800

Mr

A

Test

222

Road

City

AB1 2CD

H

S

23/11/2022 12:10

3912803

Mr

A

Test

223

Road

City

AB1 2CD

H

S

23/11/2022 12:37

3912804

Mr

A

Test

224

Road

City

AB1 2CD

H

S

23/11/2022 12:38

3293074

Mr

A

Test

225

Road

City

AB1 2CD

H

S

23/11/2022 12:45

3912819

Mr

A

Test

226

Road

City

AB1 2CD

H

S

23/11/2022 13:47

3912822

Mr

A

Test

227

Road

City

AB1 2CD

H

S

23/11/2022 13:59

3912827

Mr

A

Test

228

Road

City

AB1 2CD

H

S

23/11/2022 14:00

3912826

Mr

A

Test

229

Road

City

AB1 2CD

H

S

23/11/2022 14:00

2453188

Mr

A

Test

230

Road

City

AB1 2CD

S

H

23/11/2022 14:01

3898131

Mr

A

Test

231

Road

City

AB1 2CD

H

S

23/11/2022 14:02

3912811

Mr

A

Test

232

Road

City

AB1 2CD

H

S

23/11/2022 14:02

3912733

Mr

A

Test

233

Road

City

AB1 2CD

H

S

23/11/2022 14:02

3779152

Mr

A

Test

234

Road

City

AB1 2CD

S

H

23/11/2022 14:02

3912801

Mr

A

Test

235

Road

City

AB1 2CD

H

S

23/11/2022 14:03

1307112

Mr

A

Test

236

Road

City

AB1 2CD

S

H

23/11/2022 14:05

3573709

Mr

A

Test

237

Road

City

AB1 2CD

S

H

23/11/2022 14:13

3755544

Mr

A

Test

238

Road

City

AB1 2CD

H

S

23/11/2022 14:51

3860378

Mr

A

Test

239

Road

City

AB1 2CD

H

S

23/11/2022 15:19

3912844

Mr

A

Test

240

Road

City

AB1 2CD

H

S

23/11/2022 15:23

3912843

Mr

A

Test

241

Road

City

AB1 2CD

H

S

23/11/2022 15:43

1878364

Mr

A

Test

242

Road

City

AB1 2CD

S

H

23/11/2022 15:43

3865485

Mr

A

Test

243

Road

City

AB1 2CD

H

S

23/11/2022 15:44

3912836

Mr

A

Test

244

Road

City

AB1 2CD

H

S

23/11/2022 15:46

3912693

Mr

A

Test

245

Road

City

AB1 2CD

H

S

23/11/2022 15:49

3911890

Mr

A

Test

246

Road

City

AB1 2CD

H

S

23/11/2022 15:49

3912748

Mr

A

Test

247

Road

City

AB1 2CD

H

S

23/11/2022 15:57

3912852

Mr

A

Test

248

Road

City

AB1 2CD

H

S

23/11/2022 16:09

3305749

Mr

A

Test

249

Road

City

AB1 2CD

H

S

23/11/2022 17:03

3912845

Mr

A

Test

250

Road

City

AB1 2CD

H

S

23/11/2022 17:04

3912743

Mr

A

Test

251

Road

City

AB1 2CD

H

S

23/11/2022 17:26

2057311

Mr

A

Test

252

Road

City

AB1 2CD

S

H

23/11/2022 18:47

3908018

Mr

A

Test

253

Road

City

AB1 2CD

H

S

23/11/2022 19:16

3803408

Mr

A

Test

254

Road

City

AB1 2CD

B

23/11/2022 09:47

3912671

Mr

A

Test

255

Road

City

AB1 2CD

B

23/11/2022 09:53

3912762

Mr

A

Test

256

Road

City

AB1 2CD

B

23/11/2022 10:09

2856000

Mr

A

Test

257

Road

City

AB1 2CD

B

23/11/2022 10:16

3363023

Mr

A

Test

258

Road

City

AB1 2CD

B

23/11/2022 10:56

3044677

Mr

A

Test

259

Road

City

AB1 2CD

B

23/11/2022 10:57

1510066

Mr

A

Test

260

Road

City

AB1 2CD

B

23/11/2022 10:57

3572647

Mr

A

Test

261

Road

City

AB1 2CD

B

23/11/2022 10:58

3912720

Mr

A

Test

262

Road

City

AB1 2CD

B

23/11/2022 10:58

2786288

Mr

A

Test

263

Road

City

AB1 2CD

B

23/11/2022 10:58

3808234

Mr

A

Test

264

Road

City

AB1 2CD

B

23/11/2022 10:59

3459020

Mr

A

Test

265

Road

City

AB1 2CD

B

23/11/2022 10:59

3702122

Mr

A

Test

266

Road

City

AB1 2CD

B

23/11/2022 10:59

3682502

Mr

A

Test

267

Road

City

AB1 2CD

B

23/11/2022 10:59

3912785

Mr

A

Test

268

Road

City

AB1 2CD

B

23/11/2022 11:29

3912787

Mr

A

Test

269

Road

City

AB1 2CD

B

23/11/2022 11:39

3836709

Mr

A

Test

270

Road

City

AB1 2CD

B

23/11/2022 11:40

3912775

Mr

A

Test

271

Road

City

AB1 2CD

B

23/11/2022 11:40

2473190

Mr

A

Test

272

Road

City

AB1 2CD

B

23/11/2022 11:40

2617263

Mr

A

Test

273

Road

City

AB1 2CD

B

23/11/2022 11:41

3909356

Mr

A

Test

274

Road

City

AB1 2CD

B

23/11/2022 11:42

3837712

Mr

A

Test

275

Road

City

AB1 2CD

B

23/11/2022 11:43

3788169

Mr

A

Test

276

Road

City

AB1 2CD

B

23/11/2022 11:43

3779477

Mr

A

Test

277

Road

City

AB1 2CD

B

23/11/2022 11:43

3619551

Mr

A

Test

278

Road

City

AB1 2CD

B

23/11/2022 11:44

3257312

Mr

A

Test

279

Road

City

AB1 2CD

B

23/11/2022 11:44

3854434

Mr

A

Test

280

Road

City

AB1 2CD

B

23/11/2022 11:48

3712039

Mr

A

Test

281

Road

City

AB1 2CD

B

23/11/2022 11:48

3279487

Mr

A

Test

282

Road

City

AB1 2CD

B

23/11/2022 11:48

3101217

Mr

A

Test

283

Road

City

AB1 2CD

B

23/11/2022 11:49

3912756

Mr

A

Test

284

Road

City

AB1 2CD

B

23/11/2022 11:49

3250392

Mr

A

Test

285

Road

City

AB1 2CD

B

23/11/2022 11:50

2475141

Mr

A

Test

286

Road

City

AB1 2CD

B

23/11/2022 11:50

1927505

Mr

A

Test

287

Road

City

AB1 2CD

B

23/11/2022 11:50

1785249

Mr

A

Test

288

Road

City

AB1 2CD

B

23/11/2022 11:51

3912749

Mr

A

Test

289

Road

City

AB1 2CD

B

23/11/2022 11:51

3363388

Mr

A

Test

290

Road

City

AB1 2CD

B

23/11/2022 11:51

3912788

Mr

A

Test

291

Road

City

AB1 2CD

B

23/11/2022 11:56

3912792

Mr

A

Test

292

Road

City

AB1 2CD

B

23/11/2022 11:57

3016864

Mr

A

Test

293

Road

City

AB1 2CD

B

23/11/2022 11:58

3911730

Mr

A

Test

294

Road

City

AB1 2CD

B

23/11/2022 12:00

3912776

Mr

A

Test

295

Road

City

AB1 2CD

B

23/11/2022 12:00

3612458

Mr

A

Test

296

Road

City

AB1 2CD

B

23/11/2022 12:00

2581391

Mr

A

Test

297

Road

City

AB1 2CD

B

23/11/2022 12:00

3912769

Mr

A

Test

298

Road

City

AB1 2CD

B

23/11/2022 12:01

3912791

Mr

A

Test

299

Road

City

AB1 2CD

B

23/11/2022 12:01

3912793

Mr

A

Test

300

Road

City

AB1 2CD

B

23/11/2022 12:01

3729801

Mr

A

Test

301

Road

City

AB1 2CD

B

23/11/2022 12:05

3912781

Mr

A

Test

302

Road

City

AB1 2CD

B

23/11/2022 12:05

3739761

Mr

A

Test

303

Road

City

AB1 2CD

B

23/11/2022 12:06

3912795

Mr

A

Test

304

Road

City

AB1 2CD

B

23/11/2022 12:07

3817800

Mr

A

Test

305

Road

City

AB1 2CD

B

23/11/2022 12:10

3912803

Mr

A

Test

306

Road

City

AB1 2CD

B

23/11/2022 12:37

3912804

Mr

A

Test

307

Road

City

AB1 2CD

B

23/11/2022 12:38

3293074

Mr

A

Test

308

Road

City

AB1 2CD

B

23/11/2022 12:45

3912819

Mr

A

Test

309

Road

City

AB1 2CD

B

23/11/2022 13:47

3912822

Mr

A

Test

310

Road

City

AB1 2CD

B

23/11/2022 13:59

3912827

Mr

A

Test

311

Road

City

AB1 2CD

B

23/11/2022 14:00

3912826

Mr

A

Test

312

Road

City

AB1 2CD

B

23/11/2022 14:00

2453188

Mr

A

Test

313

Road

City

AB1 2CD

B

23/11/2022 14:01

3898131

Mr

A

Test

314

Road

City

AB1 2CD

B

23/11/2022 14:02

3912811

Mr

A

Test

315

Road

City

AB1 2CD

B

23/11/2022 14:02

3912733

Mr

A

Test

316

Road

City

AB1 2CD

B

23/11/2022 14:02

3779152

Mr

A

Test

317

Road

City

AB1 2CD

B

23/11/2022 14:02

3912801

Mr

A

Test

318

Road

City

AB1 2CD

B

23/11/2022 14:03

1307112

Mr

A

Test

319

Road

City

AB1 2CD

B

23/11/2022 14:05

3573709

Mr

A

Test

320

Road

City

AB1 2CD

B

23/11/2022 14:13

3755544

Mr

A

Test

321

Road

City

AB1 2CD

B

23/11/2022 14:51

3860378

Mr

A

Test

322

Road

City

AB1 2CD

B

23/11/2022 15:19

3912844

Mr

A

Test

323

Road

City

AB1 2CD

B

23/11/2022 15:23

3912843

Mr

A

Test

324

Road

City

AB1 2CD

B

23/11/2022 15:43

1878364

Mr

A

Test

325

Road

City

AB1 2CD

B

23/11/2022 15:43

3865485

Mr

A

Test

326

Road

City

AB1 2CD

B

23/11/2022 15:44

3912836

Mr

A

Test

327

Road

City

AB1 2CD

B

23/11/2022 15:46

3912693

Mr

A

Test

328

Road

City

AB1 2CD

B

23/11/2022 15:49

3911890

Mr

A

Test

329

Road

City

AB1 2CD

B

23/11/2022 15:49

3912748

Mr

A

Test

330

Road

City

AB1 2CD

B

23/11/2022 15:57

3912852

Mr

A

Test

331

Road

City

AB1 2CD

B

23/11/2022 16:09

3305749

Mr

A

Test

332

Road

City

AB1 2CD

B

23/11/2022 17:03

3912845

Mr

A

Test

333

Road

City

AB1 2CD

B

23/11/2022 17:04

3912743

Mr

A

Test

334

Road

City

AB1 2CD

B

23/11/2022 17:26

2057311

Mr

A

Test

335

Road

City

AB1 2CD

B

23/11/2022 18:47

3908018

Mr

A

Test

336

Road

City

AB1 2CD

B

23/11/2022 19:16

Upvote 0

Fluff

MrExcel MVP, Moderator

Nov 24, 2022

#4

How about

Fluff.xlsm

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

Customer Number

Title

Firstname

Lastname

Add Line 1

Add Line 2

Add Line 3

City

Postcode

Broucher Type 1

Broucher Type 2

Broucher Type 3

Entry Date

Weight

2

3912711

Mr

A

Test

126

Road

City

AB1 2CD

B

23/11/2022 09:45

3

3912780

Mr

A

Test

133

Road

City

AB1 2CD

B

23/11/2022 10:54

4

3446122

Mr

A

Test

134

Road

City

AB1 2CD

B

23/11/2022 10:58

5

1727943

Mr

A

Test

136

Road

City

AB1 2CD

B

23/11/2022 11:10

6

3912864

Mr

A

Test

169

Road

City

AB1 2CD

B

23/11/2022 18:46

7

3912870

Mr

A

Test

170

Road

City

AB1 2CD

B

23/11/2022 19:11

8

3803408

Mr

A

Test

254

Road

City

AB1 2CD

B

23/11/2022 09:47

9

3912671

Mr

A

Test

255

Road

City

AB1 2CD

B

23/11/2022 09:53

10

3912762

Mr

A

Test

256

Road

City

AB1 2CD

B

23/11/2022 10:09

11

2856000

Mr

A

Test

257

Road

City

AB1 2CD

B

23/11/2022 10:16

12

3363023

Mr

A

Test

258

Road

City

AB1 2CD

B

23/11/2022 10:56

13

3044677

Mr

A

Test

259

Road

City

AB1 2CD

B

23/11/2022 10:57

14

1510066

Mr

A

Test

260

Road

City

AB1 2CD

B

23/11/2022 10:57

15

3646672

Mr

A

Test

130

Road

City

AB1 2CD

S

23/11/2022 10:12

16

3290757

Mr

A

Test

131

Road

City

AB1 2CD

S

23/11/2022 10:31

17

3702449

Mr

A

Test

132

Road

City

AB1 2CD

S

23/11/2022 10:35

18

3795124

Mr

A

Test

143

Road

City

AB1 2CD

S

23/11/2022 12:11

19

3912735

Mr

A

Test

125

Road

City

AB1 2CD

H

23/11/2022 09:38

20

3912508

Mr

A

Test

135

Road

City

AB1 2CD

H

23/11/2022 10:59

21

3906499

Mr

A

Test

138

Road

City

AB1 2CD

H

23/11/2022 11:25

22

3912742

Mr

A

Test

155

Road

City

AB1 2CD

H

23/11/2022 13:44

23

3912809

Mr

A

Test

150

Road

City

AB1 2CD

H

S

23/11/2022 12:47

24

3877788

Mr

A

Test

157

Road

City

AB1 2CD

H

S

23/11/2022 14:01

25

3803408

Mr

A

Test

171

Road

City

AB1 2CD

S

H

23/11/2022 09:47

26

3912671

Mr

A

Test

172

Road

City

AB1 2CD

H

S

23/11/2022 09:53

27

3912762

Mr

A

Test

173

Road

City

AB1 2CD

H

S

23/11/2022 10:09

28

2856000

Mr

A

Test

174

Road

City

AB1 2CD

S

H

23/11/2022 10:16

29

3363023

Mr

A

Test

175

Road

City

AB1 2CD

S

H

23/11/2022 10:56

30

3044677

Mr

A

Test

176

Road

City

AB1 2CD

S

H

23/11/2022 10:57

31

1510066

Mr

A

Test

177

Road

City

AB1 2CD

S

H

23/11/2022 10:57

32

3572647

Mr

A

Test

178

Road

City

AB1 2CD

H

S

23/11/2022 10:58

33

3912720

Mr

A

Test

179

Road

City

AB1 2CD

H

S

23/11/2022 10:58

34

2786288

Mr

A

Test

180

Road

City

AB1 2CD

S

H

23/11/2022 10:58

35

3808234

Mr

A

Test

181

Road

City

AB1 2CD

H

S

23/11/2022 10:59

36

3912759

Mr

A

Test

123

Road

City

AB1 2CD

B

S

23/11/2022 09:31

37

3912761

Mr

A

Test

124

Road

City

AB1 2CD

B

S

23/11/2022 09:31

38

3912760

Mr

A

Test

127

Road

City

AB1 2CD

B

S

23/11/2022 10:03

39

3912751

Mr

A

Test

128

Road

City

AB1 2CD

B

S

23/11/2022 10:03

40

3912723

Mr

A

Test

129

Road

City

AB1 2CD

B

S

23/11/2022 10:03

41

3912766

Mr

A

Test

140

Road

City

AB1 2CD

B

S

23/11/2022 12:01

42

3912728

Mr

A

Test

144

Road

City

AB1 2CD

B

S

23/11/2022 12:13

43

3912687

Mr

A

Test

145

Road

City

AB1 2CD

B

S

23/11/2022 12:14

44

3912813

Mr

A

Test

152

Road

City

AB1 2CD

B

S

23/11/2022 13:31

45

3912796

Mr

A

Test

153

Road

City

AB1 2CD

B

S

23/11/2022 13:33

46

3912790

Mr

A

Test

154

Road

City

AB1 2CD

S

B

23/11/2022 13:35

47

3912817

Mr

A

Test

156

Road

City

AB1 2CD

B

S

23/11/2022 13:49

48

3910147

Mr

A

Test

160

Road

City

AB1 2CD

B

H

23/11/2022 14:34

49

3912510

Mr

A

Test

166

Road

City

AB1 2CD

B

S

23/11/2022 16:09

50

3912851

Mr

A

Test

167

Road

City

AB1 2CD

B

S

23/11/2022 16:09

51

3912855

Mr

A

Test

168

Road

City

AB1 2CD

B

S

23/11/2022 17:01

Data

Cell Formulas
Range	Formula
N2:N51	N2	=IFNA(MATCH(CONCAT(SORT(J2:L2,,,1)),{"B","S","H","HS"},0),5)

Upvote 0

N

nastyveg

New Member

Nov 28, 2022

#5

Thanks for this, works perfectly.

Upvote 0

Fluff

MrExcel MVP, Moderator

Nov 28, 2022

#6

Glad we could help & thanks for the feedback.

Upvote 0

You must log in or register to reply here.

Similar threads

H

Solved

Search for topics based on their groups.

Replies: 7

Views: 140

Mar 17, 2024

Peter_SSs

Solved

Extract individual lines from cell

Replies: 6

Views: 239

Jan 29, 2024

SaraWitch

F

Question

Need to find and highlight values from high column which are greater than 10 times low value but on same expiry date,same strike price,same option typ

Replies: 3

Views: 309

Oct 23, 2023

etaf

P

Solved

Choose Max Date

Replies: 7

Views: 479

Jul 13, 2023

Joe4

1

Question

Calculate on every third Friday of the month and show results between positive & negative weeks

2

Replies: 14

Views: 503

Jan 15, 2024

15minoffame

1

Share:

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Forum statistics

Threads: 1,215,006

Messages: 6,122,665

Members: 449,091

Latest member: peppernaut

Share this page

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Top