EXTRAPOLATE DATA FROM A TABLE!!!

[Mandeep23]

Hi Guys,

I have some generic data that I need to sort but I'm finding it extremely difficult! Any help would be much appreciated!

I have the following criteria:
Find all customer that has order for the first time; within the last week that no previously data history
Find all customer that has ordered more than once within 6 months; within the last week
Find all customer that has ordered once after 6 months; within the last week
Find all the customers that haven't ordered in the last 12 months within the last week

I have pasted the mini-sheet below that doesn't go that far back, but would appreciate any formula or methods so I can easily pull this data!!

Criteria.xlsx
	A	B	C	D
1	Order	Ordered Date	Name	Total
2	1	Sun 7th Nov, 22:13	Ann Vicens-Morton	104.9
3	2	Sun 7th Nov, 21:15	David Yates	364.8
4	3	Sun 7th Nov, 21:09	Aisha Patel	104
5	4	Sun 7th Nov, 21:01	frankie o'shea	74.95
6	5	Sun 7th Nov, 20:35	Tracy Pickles	139.85
7	6	Sun 7th Nov, 20:10	John Braid	91.88
8	7	Sun 7th Nov, 19:53	Marc Gilly	114.85
9	8	Sun 7th Nov, 19:50	Jeremy Kirk	110
10	9	Sun 7th Nov, 19:38	Jonathan Pearson	120.6
11	10	Sun 7th Nov, 19:24	K Fowler	125.9
12	11	Sun 7th Nov, 19:20	JOHN GRIMMETT	124.85
13	12	Sun 7th Nov, 18:52	Joe Kemm	145.8
14	13	Sun 7th Nov, 18:51	Anthony Yaskin	140
15	14	Sun 7th Nov, 18:50	Mark Downing	102.44
16	15	Sun 7th Nov, 18:46	Aaron Denton	186.9
17	16	Sun 7th Nov, 18:45	Sam Hurrell-wills	70.05
18	17	Sun 7th Nov, 18:43	Elaine Campbell	204.95
19	18	Sun 7th Nov, 18:32	Cameron Troops	31.85
20	19	Sun 7th Nov, 18:23	Lyndsay Traherne-Williams	64.9
21	20	Sun 7th Nov, 17:59	Gareth Lawrence	80
22	21	Sun 7th Nov, 17:46	Jade Pennick	39.8
23	22	Sun 7th Nov, 17:36	Sam Horner	105.8
24	23	Sun 7th Nov, 17:31	Robert Tarn	103.75
25	24	Sun 7th Nov, 17:01	Tahir Riaz	203.15
26	25	Sun 7th Nov, 16:59	Toby Miller	161.85
27	26	Sun 7th Nov, 16:57	Annmarie Wilson	106.6
28	27	Sun 7th Nov, 16:44	Chris Teasdale	84.95
29	28	Sun 7th Nov, 16:38	Joss Gale	148.95
30	29	Sun 7th Nov, 16:30	Noel Wallenberg	120.85
31	30	Sun 7th Nov, 16:29	Matt thomas	109.9
32	31	Sun 7th Nov, 16:28	edward richert	242.9
33	32	Sun 7th Nov, 16:10	Michael de Vyver	93.85
34	33	Sun 7th Nov, 15:48	Hayden Foster	149.95
35	34	Sun 7th Nov, 15:47	Arthur Hamilton	124.85
36	35	Sun 7th Nov, 15:42	Ronan Gilbert	109.9
37	36	Sun 7th Nov, 15:27	Yvonne Jacobs	114.95
38	37	Sun 7th Nov, 15:14	Matthew Li Kam Wa	113.85
39	38	Sun 7th Nov, 15:00	Rod Love	108.75
40	39	Sun 7th Nov, 14:58	margaret Hone	85.56
41	40	Sun 7th Nov, 14:42	Raiyan Awan	154.46
42	41	Sun 7th Nov, 14:29	Peter Murty	64.9
43	42	Sun 7th Nov, 14:29	Debbie Taylor	80.64
44	43	Sun 7th Nov, 14:08	Peter Blemings	84.68
45	44	Sun 7th Nov, 14:06	federico cincotta	130.75
46	45	Sun 7th Nov, 14:04	alastair Conway	119.95
47	46	Sun 7th Nov, 13:47	Tom Sirett	161.5
48	47	Sun 7th Nov, 13:39	Robert Thomas	110.8
49	48	Sun 7th Nov, 13:39	Andrew Nourish	186.83
50	49	Sun 7th Nov, 13:32	Sam Bateman	109.9
51	50	Sun 7th Nov, 13:32	Julian Seifert	64.9
52	51	Sun 7th Nov, 13:25	Luke Burnett	110.8
53	52	Sun 7th Nov, 13:24	Charles Fraser	64.9
54	53	Sun 7th Nov, 13:18	Laurence Herzberg	139.76
55	54	Sun 7th Nov, 13:08	Lorna Earley	102.7
56	55	Sun 7th Nov, 12:58	TONY WELLS	212.75
57	56	Sun 7th Nov, 12:53	PETER EARDLEY	120
58	57	Sun 7th Nov, 12:50	jack bithell	77.87
59	58	Sun 7th Nov, 12:44	Sarah-jane Legge	54.9
60	59	Sun 7th Nov, 12:33	Paul Edwards	138.48
61	60	Sun 7th Nov, 12:32	Mark James	89.95
62	61	Sun 7th Nov, 12:27	michael ansell	114.95
63	62	Sun 7th Nov, 12:17	Aidan Sinclair	123.8
64	63	Sun 7th Nov, 12:12	Vera Mutimer	163.85
65	64	Sun 7th Nov, 12:11	Iain Marr	64.9
66	65	Sun 7th Nov, 11:42	steve moloney	64.95
67	66	Sun 7th Nov, 08:55	Chris Baker	58.85
68	67	Sun 7th Nov, 01:55	Scott Big on beauty	64.9
69	68	Sat 6th Nov, 22:43	EMMA XIE	69.9
70	69	Sat 6th Nov, 22:40	Loutfig Murfitt	59.9
71	70	Sat 6th Nov, 22:20	Jan Hoong Ho	111.9
72	71	Sat 6th Nov, 21:14	Rob Torres	83.92
73	72	Sat 6th Nov, 20:36	IVAN WOODHOUSE	299.5
74	73	Sat 6th Nov, 20:27	paul turner	283.95
75	74	Sat 6th Nov, 20:21	Kay Leach	107.96
76	75	Sat 6th Nov, 20:15	Wladyslaw Tabis	109.9
77	76	Sat 6th Nov, 18:31	Marcus Hennessey	140
78	77	Sat 6th Nov, 18:00	Emily Ridley	39.9
79	78	Sat 6th Nov, 17:22	Steve Hance	123.9475
80	79	Sat 6th Nov, 17:14	Henry Worth	49.9
81	80	Sat 6th Nov, 17:02	Mike Difrancesco	66.63
82	81	Sat 6th Nov, 16:36	Jonathan Desler	100
83	82	Sat 6th Nov, 16:18	Roxanne Smith	69.95
84	83	Sat 6th Nov, 16:12	Fran Martinez	74.95
85	84	Sat 6th Nov, 15:08	Simeonas Kozemiakinas	299.95
86	85	Sat 6th Nov, 14:38	Jayson Soriano	121.51
87	86	Sat 6th Nov, 13:49	Andy O’Boyle	104.85
88	87	Sat 6th Nov, 13:40	ian kendal	99.33
89	88	Sat 6th Nov, 13:23	Michael Leung	80
90	89	Sat 6th Nov, 12:45	Kaylum Ball	80
91	90	Sat 6th Nov, 12:34	Chris Sheridan	110
92	91	Sat 6th Nov, 06:58	Gunay Oksar	118
93	92	Sat 6th Nov, 06:47	Gunay Oksar	100
94	93	Fri 5th Nov, 23:52	Yoan Wong	321.9
95	94	Fri 5th Nov, 23:50	Gavin Walley	100
96	95	Fri 5th Nov, 23:06	Ahmed Omran	79.85
97	96	Fri 5th Nov, 22:51	Dean Rochester	115.65
98	97	Fri 5th Nov, 22:14	Graham peel	59.9
99	98	Fri 5th Nov, 21:03	Andrew Saville	143.85
100	99	Fri 5th Nov, 20:58	Jon Curtis	39.9
101	100	Fri 5th Nov, 19:40	Omar Paracha	130.7
102	101	Fri 5th Nov, 19:29	Simon Kirby	80
103	102	Fri 5th Nov, 19:05	Penny Cawley	0
104	103	Fri 5th Nov, 18:29	Mark Green	110.5
105	104	Fri 5th Nov, 18:22	Kwok Lee	118.85
106	105	Fri 5th Nov, 17:53	Simon Hurst	140
107	106	Fri 5th Nov, 17:27	David Cox	159.8
108	107	Fri 5th Nov, 16:41	Jackie Barton	91.8
109	108	Fri 5th Nov, 16:38	John Warren	165
110	109	Fri 5th Nov, 16:24	Anton Richter	669.95
111	110	Fri 5th Nov, 15:50	Jonathan Truman	100
112	111	Fri 5th Nov, 15:20	Ciaran Clemmow	180
113	112	Fri 5th Nov, 15:01	Lily Wong	80
114	113	Fri 5th Nov, 14:51	James Gilruth	319.95
115	114	Fri 5th Nov, 14:49	Svava Davies	50
116	115	Fri 5th Nov, 13:45	Wai Tung Lam	113.52
117	116	Fri 5th Nov, 13:44	Matthew Marsden	263.5
118	117	Fri 5th Nov, 13:37	Ellie Lott	69.9
119	118	Fri 5th Nov, 12:58	simon evans	80
120	119	Fri 5th Nov, 12:30	Mandy Ireland	45.8
121	120	Fri 5th Nov, 12:19	Abdur Gearay	57.75
122	121	Fri 5th Nov, 12:02	Satnam Gill	259.95
123	122	Fri 5th Nov, 11:50	John Dutton	144.95
124	123	Fri 5th Nov, 11:41	Michael McGill	114.9
125	124	Fri 5th Nov, 11:14	Imran Qureshi	165.59
126	125	Fri 5th Nov, 11:04	Deborah Hamlyn	79.75
127	126	Fri 5th Nov, 10:55	Howard Grant	300
128	127	Fri 5th Nov, 10:48	Miguel Perez Guerra	845
129	128	Fri 5th Nov, 10:31	Dan Beimborn	80
130	129	Fri 5th Nov, 09:04	miranda rowland	69.9
131	130	Fri 5th Nov, 08:06	Shelley Watson	50.85
132	131	Fri 5th Nov, 07:53	Monica Font Del Amo	160
133	132	Fri 5th Nov, 00:28	Rosanne Ching	80
134	133	Thu 4th Nov, 23:52	Pierluigi Chiusolo	80
135	134	Thu 4th Nov, 23:18	Darrell Pinkney	245.55
136	135	Thu 4th Nov, 20:54	Simon O'Brien	124.9
137	136	Thu 4th Nov, 20:26	Nick Munday	54.95
138	137	Thu 4th Nov, 20:15	Jon Rokk	80
139	138	Thu 4th Nov, 19:54	Sean Pedrosa	80
140	139	Thu 4th Nov, 19:48	Alen Corak	100
141	140	Thu 4th Nov, 19:04	Henry Maria	212.75
142	141	Thu 4th Nov, 18:57	Michel Frey	74.95
143	142	Thu 4th Nov, 18:47	Niall Maher	80
144	143	Thu 4th Nov, 18:46	Benjamin Gill	80
145	144	Thu 4th Nov, 18:44	Vic Wei	80
146	145	Thu 4th Nov, 18:35	Robert Saunders	80
147	146	Thu 4th Nov, 18:28	Giovanni Scarcelli	105.46
148	147	Thu 4th Nov, 18:23	Alan Newton	80
149	148	Thu 4th Nov, 17:59	Gideon Holdway	61.85
150	149	Thu 4th Nov, 17:37	Tom Barker	97.8
151	150	Thu 4th Nov, 17:21	Tom Barker	94.9
152	151	Thu 4th Nov, 16:36	Josh Harcourt	165.9
153	152	Thu 4th Nov, 16:02	Georgios Becatoros	319.9
154	153	Thu 4th Nov, 15:29	Julian Evans	50.7
155	154	Thu 4th Nov, 14:42	Giles Forster	220
156	155	Thu 4th Nov, 14:26	denis artunse	380
157	156	Thu 4th Nov, 14:17	Douglas McMahon	29.9
158	157	Thu 4th Nov, 13:57	Dr. M.S. Amin	104.85
159	158	Thu 4th Nov, 13:33	Simon Ward	131.55
160	159	Thu 4th Nov, 13:05	Sam Cunningham-king	59.9
161	160	Thu 4th Nov, 13:03	ZANONE GIANCARLO	154.95
162	161	Thu 4th Nov, 12:57	David Wood	0
163	162	Thu 4th Nov, 12:48	Ercan Gurlek	104.85
164	163	Thu 4th Nov, 12:29	Hasan Hashwani	279.65
165	164	Thu 4th Nov, 12:15	ANDREW MCMASTER	79.95
166	165	Thu 4th Nov, 12:11	Jon Bentley	0
167	166	Thu 4th Nov, 11:58	MICHAEL lawson	103.96
168	167	Thu 4th Nov, 11:41	Philip Chi Ho	152.75
169	168	Thu 4th Nov, 11:09	Michael Roberts	0
170	169	Thu 4th Nov, 10:56	Alex Wisbey	65.12
171	170	Thu 4th Nov, 10:55	Gavin Rowlands	27.9
172	171	Thu 4th Nov, 09:17	Marta Lima	263.5
173	172	Thu 4th Nov, 09:08	Lauren Cloud	69.85
174	173	Thu 4th Nov, 08:36	Sean Phillips	34.95
175	174	Thu 4th Nov, 08:31	Paul Argent	69.85
176	175	Thu 4th Nov, 06:43	Anam Choudrey	64.8
177	176	Wed 3rd Nov, 22:07	Juan Carlos Gallardo	109.75
178	177	Wed 3rd Nov, 21:16	Khadeja Nayed	39.9
179	178	Wed 3rd Nov, 20:56	Roberto Barcellona	139.95
180	179	Wed 3rd Nov, 20:26	Chris Roberts	169.9
181	180	Wed 3rd Nov, 20:22	joel loader	55.85
182	181	Wed 3rd Nov, 19:48	Stephen Cotterill	89.95
183	182	Wed 3rd Nov, 19:23	Andrew Derbyshire	44.9
184	183	Wed 3rd Nov, 19:23	Matthew Hepworth	89.95
185	184	Wed 3rd Nov, 19:13	Carlos De Aniceto	124.85
186	185	Wed 3rd Nov, 16:11	Edward Davies	129.67
187	186	Wed 3rd Nov, 15:55	Mike Wort	109.95
188	187	Wed 3rd Nov, 15:27	Paul Atherton	90
189	188	Wed 3rd Nov, 14:54	Mark Telford	69.85
190	189	Wed 3rd Nov, 14:48	Vanessa Hetherington	84.8
191	190	Wed 3rd Nov, 14:45	Stacey Leigh Spalding	103.96
192	191	Wed 3rd Nov, 14:43	Peter Sheath	0
193	192	Wed 3rd Nov, 14:33	Neil White	320
194	193	Wed 3rd Nov, 14:21	Andrew Jefferies	100
195	194	Wed 3rd Nov, 14:14	Paul Klaiber	108.95
196	195	Wed 3rd Nov, 13:59	shaun gibson	130
197	196	Wed 3rd Nov, 13:57	DARREN BLAKE	119.65
198	197	Wed 3rd Nov, 13:56	Garry Smith	104.9
199	198	Wed 3rd Nov, 13:11	June Li	247.88
200	199	Wed 3rd Nov, 12:10	Martin Miller	116.9
201	200	Wed 3rd Nov, 12:08	oscar stevenson	89.95
202	201	Wed 3rd Nov, 11:56	Jamie Eagell	198
203	202	Wed 3rd Nov, 11:20	Jonathan Rivers	0
204	203	Wed 3rd Nov, 11:09	Chris Wiggins	97.12
205	204	Wed 3rd Nov, 11:03	Chris Socratous	120
206	205	Wed 3rd Nov, 10:57	Umair Saeed	199.95
207	206	Wed 3rd Nov, 10:50	Maureen Bennett	0
208	207	Wed 3rd Nov, 10:25	Jas Rajasansir	46.85
209	208	Wed 3rd Nov, 10:25	Nick Day	49.9
210	209	Wed 3rd Nov, 10:18	Akeel Karim	111.88
211	210	Wed 3rd Nov, 09:33	Tony Yuill	29.9
212	211	Wed 3rd Nov, 08:26	Andrew Smellie	139.95
213	212	Wed 3rd Nov, 08:25	andrew murrin	79.95
214	213	Wed 3rd Nov, 08:09	Sylvia Chai	225.9
215	214	Wed 3rd Nov, 06:36	Tim Tharratt	94.95
216	215	Wed 3rd Nov, 06:07	Carl Kirby	100.75
217	216	Wed 3rd Nov, 04:23	SHAMEEL SUHAIL	51.9
218	217	Tue 2nd Nov, 22:13	Werda Botan	59.85
219	218	Tue 2nd Nov, 22:08	Angeline Heffer	283.72
220	219	Tue 2nd Nov, 22:07	Andrew Steel	125
221	220	Tue 2nd Nov, 21:40	Barry Haggerty	160
222	221	Tue 2nd Nov, 21:23	Yiling Zhu	80
223	222	Tue 2nd Nov, 21:20	Ryan Nicholls	89.95
224	223	Tue 2nd Nov, 21:12	Angela Garner	144.95
225	224	Tue 2nd Nov, 21:10	Ioannis Tanes	160
226	225	Tue 2nd Nov, 21:06	Pavel Dubrouski	355.79
227	226	Tue 2nd Nov, 20:26	Rhys Jones	117.9
228	227	Tue 2nd Nov, 20:24	Justin Mycroft	99.95
229	228	Tue 2nd Nov, 19:50	Paul McDermid	101.58
230	229	Tue 2nd Nov, 19:48	SAVA TIHOV	199.12
231	230	Tue 2nd Nov, 19:33	Ryan Goff	44.9
232	231	Tue 2nd Nov, 19:24	Victoria Hatch	113
233	232	Tue 2nd Nov, 19:17	Paul White	110.85
234	233	Tue 2nd Nov, 18:51	Daniel Mclaughlin	109.95
235	234	Tue 2nd Nov, 18:51	Mandy Davis	107.95
236	235	Tue 2nd Nov, 18:48	alun dyde	124.85
237	236	Tue 2nd Nov, 18:15	Rachel Guest	181.36
238	237	Tue 2nd Nov, 18:11	Tom Byford	116.95
239	238	Tue 2nd Nov, 17:41	MD Belal	258.9
240	239	Tue 2nd Nov, 17:13	Amir Sayes	57.07
241	240	Tue 2nd Nov, 17:05	Antonio Munoz Bailey	157.17
242	241	Tue 2nd Nov, 16:45	Graham Beales	219.85
243	242	Tue 2nd Nov, 16:45	David Amber	84.9
244	243	Tue 2nd Nov, 16:43	Suleyman Simsek	60.83
245	244	Tue 2nd Nov, 16:38	Spencer Riddle	114.95
246	245	Tue 2nd Nov, 16:02	M MOROS	108
247	246	Tue 2nd Nov, 16:01	David Williams	174.65
248	247	Tue 2nd Nov, 15:35	Connor Mchugh	79.95
249	248	Tue 2nd Nov, 15:07	christopher busby	60.8
250	249	Tue 2nd Nov, 15:02	Jackie Farrands	61.95
251	250	Tue 2nd Nov, 14:52	David Blair	101.85
252	251	Tue 2nd Nov, 14:39	Lorna Willgress	100.52
253	252	Tue 2nd Nov, 14:34	Farouq Sheikh	359.04
254	253	Tue 2nd Nov, 14:27	Lucas Rocha	83.7
255	254	Tue 2nd Nov, 13:57	M Ahmed	19.95
256	255	Tue 2nd Nov, 13:35	Nick Goodfellow	104.9
257	256	Tue 2nd Nov, 13:24	Paul Richardson	119.95
258	257	Tue 2nd Nov, 13:22	Przemyslaw Krajcer	107.95
259	258	Tue 2nd Nov, 13:15	kingsleigh hammond	153.85
260	259	Tue 2nd Nov, 13:11	Shohib Tariq	130
261	260	Tue 2nd Nov, 13:07	Abraham DAHAN BENAIM	182.92
262	261	Tue 2nd Nov, 12:46	David Armstrong	106.7
263	262	Tue 2nd Nov, 12:43	Calli Amiras	112.25
264	263	Tue 2nd Nov, 12:11	Eddy Trivett	130
265	264	Tue 2nd Nov, 11:33	Sabrina Haque-Amin	102.8
266	265	Tue 2nd Nov, 11:32	Kate Tulloch	38.9
267	266	Tue 2nd Nov, 11:29	Konrad Stanczyk	49.9
268	267	Tue 2nd Nov, 10:46	Paul Ashcroft	55
269	268	Tue 2nd Nov, 10:30	Darren Fairweather	49.85
270	269	Tue 2nd Nov, 10:30	Sarah Burgess	102.85
271	270	Tue 2nd Nov, 10:27	Yinka Okunade	159.9
272	271	Tue 2nd Nov, 10:22	Nigel Neath	0
273	272	Tue 2nd Nov, 10:06	samuel smith	253.65
274	273	Tue 2nd Nov, 10:04	Ben Halleybone	49.9
275	274	Tue 2nd Nov, 09:53	Rachel Denning	176.8
276	275	Tue 2nd Nov, 09:52	Jayne Ankers	107.55
277	276	Tue 2nd Nov, 09:48	Tristram Allen	450
278	277	Tue 2nd Nov, 09:47	Chris Socratous	89.75
279	278	Tue 2nd Nov, 09:35	Rob Linton	100.85
280	279	Tue 2nd Nov, 08:46	Carol Petrie	169.9
281	280	Tue 2nd Nov, 07:18	Robert Gunn	39.9
282	281	Tue 2nd Nov, 07:03	Jimmy Jones	144.95
283	282	Tue 2nd Nov, 06:41	Iain Russell	84.8
284	283	Tue 2nd Nov, 06:01	Luke Cameron	109.9
285	284	Tue 2nd Nov, 03:11	Daniel Chen	104.35
286	285	Mon 1st Nov, 23:37	Peter Arch	95.8
287	286	Mon 1st Nov, 23:19	Daniel Hadley	59.9
288	287	Mon 1st Nov, 23:19	CRISTIAN FRANKIC	119.8
289	288	Mon 1st Nov, 23:19	Mohsen Mansouri	104.85
290	289	Mon 1st Nov, 23:12	Daniel Quiney	121.9
291	290	Mon 1st Nov, 23:04	christine mills	64.95
292	291	Mon 1st Nov, 23:00	Joanne Bradbury	80
293	292	Mon 1st Nov, 22:46	Ahmed Abdel-Jaber	139.75
294	293	Mon 1st Nov, 22:45	Shayla Ali	35.41
295	294	Mon 1st Nov, 22:35	Miguel Segarra	167.84
296	295	Mon 1st Nov, 22:28	Jeff Yuen	136
297	296	Mon 1st Nov, 22:23	Stephen Neale	112.9
298	297	Mon 1st Nov, 22:00	Sharon Lai	80
299	298	Mon 1st Nov, 21:54	Richard Collins	104.9
300	299	Mon 1st Nov, 21:44	Allison Ward	99.75
301	300	Mon 1st Nov, 21:29	Ewen Scott	43.8
302	301	Mon 1st Nov, 21:24	David Jackson	156.48
303	302	Mon 1st Nov, 21:12	Zeshan Alam	100
304	303	Mon 1st Nov, 21:06	B Chowdhury	41.85
305	304	Mon 1st Nov, 21:03	Ali Dhanji	259.95
306	305	Mon 1st Nov, 21:00	Robert Tarn	80
307	306	Mon 1st Nov, 20:57	Rudy Kathiravel	117.99
308	307	Mon 1st Nov, 20:53	Anna Deacon	827.04
309	308	Mon 1st Nov, 20:46	Ahmed Aboushelbaya	287.6
310	309	Mon 1st Nov, 20:45	Matthew David Gibbs	67.43
311	310	Mon 1st Nov, 20:43	Graham Allison	130.85
312	311	Mon 1st Nov, 20:34	ANN MARTIN	146.8
313	312	Mon 1st Nov, 20:31	mobeen ahmed	111.96
314	313	Mon 1st Nov, 20:30	Shabeena Maricar	108.8
315	314	Mon 1st Nov, 20:12	Adam Iqbal	49.85
316	315	Mon 1st Nov, 20:11	Shaheen Choudhry	118.65
317	316	Mon 1st Nov, 20:01	Alan Rudkin	114.67
318	317	Mon 1st Nov, 20:00	David Roberts	80
319	318	Mon 1st Nov, 19:55	Zohaib Siddiqui	119.85
320	319	Mon 1st Nov, 19:54	Robert Soultanaev	89.95
321	320	Mon 1st Nov, 19:38	Alex Nitka	49.85
322	321	Mon 1st Nov, 19:36	Robert Pickstock	72.7
323	322	Mon 1st Nov, 19:30	Imran Chohan	452.65
324	323	Mon 1st Nov, 19:25	P White	29.9
325	324	Mon 1st Nov, 19:24	Patricia Clements	49.95
326	325	Mon 1st Nov, 19:23	David Nolte	143.45
327	326	Mon 1st Nov, 19:20	Niall McKinney	155.3
328	327	Mon 1st Nov, 19:20	Ahmed Rawi	105.7
329	328	Mon 1st Nov, 19:13	Muhammad Hussain	59.85
330	329	Mon 1st Nov, 19:08	Geoff Brewis-Levie	29.9
331	330	Mon 1st Nov, 19:07	Mikhail Hessin	120
332	331	Mon 1st Nov, 19:06	Mark Rowe	29.9
333	332	Mon 1st Nov, 19:00	Andrew Mills	80
334	333	Mon 1st Nov, 19:00	Gerry Duffey	102.9
335	334	Mon 1st Nov, 18:58	Ejaz Ahmed	109.95
336	335	Mon 1st Nov, 18:57	Croz Croswell	93.75
337	336	Mon 1st Nov, 18:56	Simon Lace	29.9
338	337	Mon 1st Nov, 18:56	Gary Morris	100
339	338	Mon 1st Nov, 18:51	Leonardo Gonzalez	70.8
340	339	Mon 1st Nov, 18:50	Chris Branscombe Ling	116.95
341	340	Mon 1st Nov, 18:49	Gary Harrison	29.9
342	341	Mon 1st Nov, 18:47	Gary Morris	184.95
343	342	Mon 1st Nov, 18:46	carl mccaffrey	49.85
344	343	Mon 1st Nov, 18:45	Athif Hussain	128.75
345	344	Mon 1st Nov, 18:40	Elizabeth Mitchell	49.85
346	345	Mon 1st Nov, 18:38	Mohamed Hanif Omar	89.9
347	346	Mon 1st Nov, 18:36	Andrew Lucas	90
348	347	Mon 1st Nov, 18:36	Hugh Orange	102.95
349	348	Mon 1st Nov, 18:18	Zayba Sheikh	49.85
350	349	Mon 1st Nov, 18:17	David Charlesworth	115
351	350	Mon 1st Nov, 18:00	John Head	80
352	351	Mon 1st Nov, 17:55	Paul Elliott	250
353	352	Mon 1st Nov, 17:55	Heinz Forster	120
354	353	Mon 1st Nov, 17:55	Austin Straub	35.85
355	354	Mon 1st Nov, 17:49	Matthew Miller	1239.9
356	355	Mon 1st Nov, 17:29	Aidan Lundy	123.21
357	356	Mon 1st Nov, 17:27	James Joyce	144.95
358	357	Mon 1st Nov, 17:00	Paul Graham	80
359	358	Mon 1st Nov, 16:45	Sara Wells	164.01
360	359	Mon 1st Nov, 16:38	Karveh Cavalirie	60.9
361	360	Mon 1st Nov, 16:31	Patrick Mooney	139.95
362	361	Mon 1st Nov, 16:15	Robert Worters	185.95
363	362	Mon 1st Nov, 16:06	Danielle Graham	49.91
364	363	Mon 1st Nov, 16:00	Suryan Wirya Simunovic	80
365	364	Mon 1st Nov, 15:57	John Winder	89.95
366	365	Mon 1st Nov, 15:50	Simon Sankey	114.95
367	366	Mon 1st Nov, 15:44	David Benfell	60.8
368	367	Mon 1st Nov, 15:19	Toby Rainbow	164.95
369	368	Mon 1st Nov, 15:09	Graham Lewis	69.95
370	369	Mon 1st Nov, 15:00	Jobe Ferguson	80
371	370	Mon 1st Nov, 14:30	Amir Iqbal	159.85
372	371	Mon 1st Nov, 14:29	Sarah Elhatow-Senkuviene	61.87
373	372	Mon 1st Nov, 14:26	Giles Stafford	114.95
374	373	Mon 1st Nov, 14:04	Sahal Bhamjee	100
375	374	Mon 1st Nov, 13:49	Jonathan McCrory	100
376	375	Mon 1st Nov, 13:33	Niall Stack	41.91
377	376	Mon 1st Nov, 13:12	Ori Reiss	182.75
378	377	Mon 1st Nov, 13:10	Marion Buchan	100
379	378	Mon 1st Nov, 11:35	Peter Davies	0
380	379	Mon 1st Nov, 11:25	Chris Ansell	0
381	380	Mon 1st Nov, 11:22	Lee Starmer	0
382	381	Mon 1st Nov, 11:19	Nick March	0
383	382	Mon 1st Nov, 11:18	M Ahmed	110.42
384	383	Mon 1st Nov, 11:11	Stanley Davies	89.04
385	384	Mon 1st Nov, 10:46	Peter Kwok	340
386	385	Mon 1st Nov, 10:17	Gareth Lazell	199.8
387	386	Mon 1st Nov, 10:06	Simon Fletcher	89.0471
388	387	Mon 1st Nov, 09:58	Garry Moore	69.85
389	388	Mon 1st Nov, 09:38	Toby Topcott	174.85
390	389	Mon 1st Nov, 08:45	Philip Tucker	125
391	390	Mon 1st Nov, 03:04	Tak Chi Choy	108.7
392	391	Sun 31st Oct, 23:47	Wayne Forster	113.9
393	392	Sun 31st Oct, 23:13	Omar Al-Haffar	70.8
394	393	Sun 31st Oct, 22:34	vincent masnou	123.17
395	394	Sun 31st Oct, 22:28	David Hill	109.9
396	395	Sun 31st Oct, 22:03	Ed Farrell	74.95
397	396	Sun 31st Oct, 21:46	Ignacio Farga Ninoles	101.85
398	397	Sun 31st Oct, 20:31	Ian Anderson	65.9
399	398	Sun 31st Oct, 19:58	Thomas Simmons	37.75
400	399	Sun 31st Oct, 19:54	Daniel Taylor	103.85
401	400	Sun 31st Oct, 19:49	Jon Bentley	532.87
402	401	Sun 31st Oct, 19:45	Claudiu Tirsolea	109.9
403	402	Sun 31st Oct, 19:40	Jeremy Cooke	240
404	403	Sun 31st Oct, 19:14	Alison Porter	105.8
405	404	Sun 31st Oct, 18:54	Julie Mahmoud	100
406	405	Sun 31st Oct, 18:37	Hoa Huynh	59.9
407	406	Sun 31st Oct, 18:36	Darren Clarke	110.85
408	407	Sun 31st Oct, 18:02	ALUN MARRIOTT	61.8
409	408	Sun 31st Oct, 18:02	Saif Alomani	39.9
410	409	Sun 31st Oct, 17:59	Temuulen Nanzad	87.8
411	410	Sun 31st Oct, 17:44	Roger Taslaq	146.9
412	411	Sun 31st Oct, 17:36	Phil Bird	20.9
413	412	Sun 31st Oct, 17:32	Paul Cerisola	44.9
414	413	Sun 31st Oct, 17:29	Dimitrios Skopelitis	760
415	414	Sun 31st Oct, 17:07	Liz Glover	50.85
416	415	Sun 31st Oct, 16:52	Angela Bird	110.85
417	416	Sun 31st Oct, 16:48	Melissa Shaw	101.56
418	417	Sun 31st Oct, 16:45	Munadia Lauria	182.75
419	418	Sun 31st Oct, 16:35	Rob Lovelock	92.85
420	419	Sun 31st Oct, 16:26	John Harrhy	69.95
421	420	Sun 31st Oct, 16:25	Andy Gosheron	71.8
422	421	Sun 31st Oct, 16:19	Stephen Hamer	96.8583
423	422	Sun 31st Oct, 15:37	Dawn von Bergen	120
424	423	Sun 31st Oct, 14:38	Maryam ALI	39.9
425	424	Sun 31st Oct, 14:29	Daniel Drinkwater	54.95
426	425	Sun 31st Oct, 14:27	RUSSELL KINGSNORTH	180
427	426	Sun 31st Oct, 14:26	Glen Binns	130
428	427	Sun 31st Oct, 14:24	Patrik Burstrom	113.75
429	428	Sun 31st Oct, 13:43	Gareth Keegan	132
430	429	Sun 31st Oct, 13:40	Anthony Walters	135
431	430	Sun 31st Oct, 13:33	Isa Mohammed	60.95
432	431	Sun 31st Oct, 13:15	polina zabelina	150
433	432	Sun 31st Oct, 12:56	Shakera Tayub	170
434	433	Sun 31st Oct, 12:46	Grant Read	69.95
435	434	Sun 31st Oct, 12:46	carl mccaffrey	69.85
436	435	Sun 31st Oct, 12:43	Andrew Parraco	113.8
437	436	Sun 31st Oct, 12:42	Susan Clarke	55.75
438	437	Sun 31st Oct, 12:35	Mark Harris	158.95
439	438	Sun 31st Oct, 12:29	Jon Rokk	101.7
440	439	Sun 31st Oct, 12:20	Ian Roberts	69.95
441	440	Sun 31st Oct, 12:19	Mandy Dunn	152.6
442	441	Sun 31st Oct, 12:19	Sami Agush	69.95
443	442	Sun 31st Oct, 12:12	fraser crichton	69.95
444	443	Sun 31st Oct, 10:29	Yi Yang	134.95
445	444	Sun 31st Oct, 09:28	Tatiana Livesey	320.9
446	445	Sun 31st Oct, 09:26	Jared Tovee	63.4
447	446	Sun 31st Oct, 09:00	matthew Francis	43.4
448	447	Sun 31st Oct, 08:52	Y Nazir	89.85
449	448	Sun 31st Oct, 07:43	H Suggate	69.85
450	449	Sun 31st Oct, 07:24	Martin McNally	89.95
451	450	Sat 30th Oct, 22:01	Arshad Waheed	243.8
452	451	Sat 30th Oct, 21:50	Fay Gao	249.8
453	452	Sat 30th Oct, 21:43	David Mensik	179.95
454	453	Sat 30th Oct, 21:01	Helen Brownlees	68.9
455	454	Sat 30th Oct, 20:58	Brendon Jiang	164.85
456	455	Sat 30th Oct, 19:53	Juliet O'Mahony	172.86
457	456	Sat 30th Oct, 18:00	Ross Lynam-Carter	80
458	457	Sat 30th Oct, 17:10	James Silber	104.75
459	458	Sat 30th Oct, 15:59	Simon Cotmore	100
460	459	Sat 30th Oct, 15:09	Simon Inchley	122.95
461	460	Sat 30th Oct, 14:25	Tracy Lower	85.91
462	461	Sat 30th Oct, 13:58	Joe Hankin	115.95
463	462	Sat 30th Oct, 13:42	Emma Fish	103.95
464	463	Sat 30th Oct, 13:37	Gareth Lewis	154.95
465	464	Sat 30th Oct, 13:12	GEORGE DIAMOND	180
466	465	Sat 30th Oct, 13:05	Richard Claypole	106.86
467	466	Sat 30th Oct, 13:03	Angela Scattergood	30.85
468	467	Sat 30th Oct, 13:00	Paul Allan	80
469	468	Sat 30th Oct, 12:22	Trisha Campbell	85
470	469	Sat 30th Oct, 12:22	Stephen Smith	100.8
471	470	Sat 30th Oct, 12:06	Rob FLOYD	130
472	471	Sat 30th Oct, 12:00	Nick March	80
473	472	Sat 30th Oct, 11:54	Abdul Mehmood	189.95
474	473	Sat 30th Oct, 11:43	geoff hayllar	104.75
475	474	Sat 30th Oct, 11:41	Nick Ekendahl	161.38
476	475	Sat 30th Oct, 10:50	Ilya Belyaev	100
477	476	Sat 30th Oct, 10:45	David Carr	71.25
478	477	Sat 30th Oct, 10:33	Jonathan Wilkinson	128.95
479	478	Sat 30th Oct, 10:25	Xin Jiang	114.9
480	479	Sat 30th Oct, 08:33	P J White	110
481	480	Sat 30th Oct, 08:02	Julie Mahmoud	100
482	481	Sat 30th Oct, 01:37	LAI LIU	149.85
483	482	Sat 30th Oct, 00:10	peter sheath	49.95
484	483	Fri 29th Oct, 23:13	Shane Duffield	128.19
485	484	Fri 29th Oct, 22:51	Oliver Webb	218.2
486	485	Fri 29th Oct, 22:34	Del Flint	102.75
487	486	Fri 29th Oct, 22:10	George Tebbutt	86.45
488	487	Fri 29th Oct, 21:42	Laurel Powers-Freeling	62.5
489	488	Fri 29th Oct, 21:29	Rasheed Mosaheb	109.95
490	489	Fri 29th Oct, 21:20	craig renilson	120
491	490	Fri 29th Oct, 21:00	Amardeep Chima	80
492	491	Fri 29th Oct, 20:59	Dr. M.S. Amin	119.85
493	492	Fri 29th Oct, 20:47	Nic Lee	180
494	493	Fri 29th Oct, 20:46	Julie Mahmoud	110
495	494	Fri 29th Oct, 20:07	sajid khaliq	69.8
496	495	Fri 29th Oct, 19:42	Jason Nowell	215.85
497	496	Fri 29th Oct, 19:41	Daniel Goldfarb	48.8
498	497	Fri 29th Oct, 19:20	gavin hutcheson	69.8
499	498	Fri 29th Oct, 19:19	Guy Keng	95.8
500	499	Fri 29th Oct, 19:19	FIONA SAVORY	116.74
order-breakdown-table-2021-11-0

 

[DRSteele]

Welcome to the forum.\

Could you please re-post that data after you re-format the date column so that the each cell is an official Excel Date Serial number? Like: 11/7/2021 14:51

 

[JamesCanale]

Having trouble with Columns I and J

MrExcelPlayground4.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Order	Ordered Date	Name	Total		New customers in the last week	Customers in the last week that ordered at least once in the previous 6 months	Customers in the last week that haven't ordered in the last 12 months prior	Customers in the last week that ordered more than once in the previous 6 months	Customers in the last week that ordered exactly once in the previous 6 months		More than once	exactly once
2	1	11/7/21 22:13	Ann Vicens-Morton	104.9		Ann Vicens-Morton	Robert Tarn	Ann Vicens-Morton	#CALC!	Robert Tarn		0	0	Werda Botan
3	2	11/7/21 21:15	David Yates	364.8		David Yates	Jon Rokk	David Yates		Jon Rokk		0	0	Angeline Heffer
4	3	11/7/21 21:09	Aisha Patel	104		Aisha Patel	Dr. M.S. Amin	Aisha Patel		Dr. M.S. Amin		0	0	Andrew Steel
5	4	11/7/21 21:01	frankie o'shea	74.95		frankie o'shea	Jon Bentley	frankie o'shea		Jon Bentley		0	0	Barry Haggerty
6	5	11/7/21 20:35	Tracy Pickles	139.85		Tracy Pickles	Peter Sheath	Tracy Pickles		Peter Sheath		0	0	Yiling Zhu
7	6	11/7/21 20:10	John Braid	91.88		John Braid	Chris Socratous	John Braid		Chris Socratous		0	0	Ryan Nicholls
8	7	11/7/21 19:53	Marc Gilly	114.85		Marc Gilly		Marc Gilly				0	0	Angela Garner
9	8	11/7/21 19:50	Jeremy Kirk	110		Jeremy Kirk		Jeremy Kirk				0	0	Ioannis Tanes
10	9	11/7/21 19:38	Jonathan Pearson	120.6		Jonathan Pearson		Jonathan Pearson				0	0	Pavel Dubrouski
11	10	11/7/21 19:24	K Fowler	125.9		K Fowler		K Fowler				0	0	Rhys Jones
12	11	11/7/21 19:20	JOHN GRIMMETT	124.85		JOHN GRIMMETT		JOHN GRIMMETT				0	0	Justin Mycroft
13	12	11/7/21 18:52	Joe Kemm	145.8		Joe Kemm		Joe Kemm				0	0	Paul McDermid
14	13	11/7/21 18:51	Anthony Yaskin	140		Anthony Yaskin		Anthony Yaskin				0	0	SAVA TIHOV
15	14	11/7/21 18:50	Mark Downing	102.44		Mark Downing		Mark Downing				0	0	Ryan Goff
16	15	11/7/21 18:46	Aaron Denton	186.9		Aaron Denton		Aaron Denton				0	0	Victoria Hatch
17	16	11/7/21 18:45	Sam Hurrell-wills	70.05		Sam Hurrell-wills		Sam Hurrell-wills				0	0	Paul White
18	17	11/7/21 18:43	Elaine Campbell	204.95		Elaine Campbell		Elaine Campbell				0	0	Daniel Mclaughlin
19	18	11/7/21 18:32	Cameron Troops	31.85		Cameron Troops		Cameron Troops				0	0	Mandy Davis
20	19	11/7/21 18:23	Lyndsay Traherne-Williams	64.9		Lyndsay Traherne-Williams		Lyndsay Traherne-Williams				0	0	alun dyde
21	20	11/7/21 17:59	Gareth Lawrence	80		Gareth Lawrence		Gareth Lawrence				0	0	Rachel Guest
22	21	11/7/21 17:46	Jade Pennick	39.8		Jade Pennick		Jade Pennick				0	0	Tom Byford
23	22	11/7/21 17:36	Sam Horner	105.8		Sam Horner		Sam Horner				0	0	MD Belal
24	23	11/7/21 17:31	Robert Tarn	103.75		Tahir Riaz		Tahir Riaz				0	88	Amir Sayes
25	24	11/7/21 17:01	Tahir Riaz	203.15		Toby Miller		Toby Miller				0	0	Antonio Munoz Bailey
26	25	11/7/21 16:59	Toby Miller	161.85		Annmarie Wilson		Annmarie Wilson				0	0	Graham Beales
27	26	11/7/21 16:57	Annmarie Wilson	106.6		Chris Teasdale		Chris Teasdale				0	0	David Amber
28	27	11/7/21 16:44	Chris Teasdale	84.95		Joss Gale		Joss Gale				0	0	Suleyman Simsek
29	28	11/7/21 16:38	Joss Gale	148.95		Noel Wallenberg		Noel Wallenberg				0	0	Spencer Riddle
30	29	11/7/21 16:30	Noel Wallenberg	120.85		Matt thomas		Matt thomas				0	0	M MOROS
31	30	11/7/21 16:29	Matt thomas	109.9		edward richert		edward richert				0	0	David Williams
32	31	11/7/21 16:28	edward richert	242.9		Michael de Vyver		Michael de Vyver				0	0	Connor Mchugh
33	32	11/7/21 16:10	Michael de Vyver	93.85		Hayden Foster		Hayden Foster				0	0	christopher busby
34	33	11/7/21 15:48	Hayden Foster	149.95		Arthur Hamilton		Arthur Hamilton				0	0	Jackie Farrands
35	34	11/7/21 15:47	Arthur Hamilton	124.85		Ronan Gilbert		Ronan Gilbert				0	0	David Blair
36	35	11/7/21 15:42	Ronan Gilbert	109.9		Yvonne Jacobs		Yvonne Jacobs				0	0	Lorna Willgress
37	36	11/7/21 15:27	Yvonne Jacobs	114.95		Matthew Li Kam Wa		Matthew Li Kam Wa				0	0	Farouq Sheikh
38	37	11/7/21 15:14	Matthew Li Kam Wa	113.85		Rod Love		Rod Love				0	0	Lucas Rocha
39	38	11/7/21 15:00	Rod Love	108.75		margaret Hone		margaret Hone				0	0	M Ahmed
40	39	11/7/21 14:58	margaret Hone	85.56		Raiyan Awan		Raiyan Awan				0	0	Nick Goodfellow
41	40	11/7/21 14:42	Raiyan Awan	154.46		Peter Murty		Peter Murty				0	0	Paul Richardson
42	41	11/7/21 14:29	Peter Murty	64.9		Debbie Taylor		Debbie Taylor				0	0	Przemyslaw Krajcer
43	42	11/7/21 14:29	Debbie Taylor	80.64		Peter Blemings		Peter Blemings				0	0	kingsleigh hammond
44	43	11/7/21 14:08	Peter Blemings	84.68		federico cincotta		federico cincotta				0	0	Shohib Tariq
45	44	11/7/21 14:06	federico cincotta	130.75		alastair Conway		alastair Conway				0	0	Abraham DAHAN BENAIM
46	45	11/7/21 14:04	alastair Conway	119.95		Tom Sirett		Tom Sirett				0	0	David Armstrong
47	46	11/7/21 13:47	Tom Sirett	161.5		Robert Thomas		Robert Thomas				0	0	Calli Amiras
48	47	11/7/21 13:39	Robert Thomas	110.8		Andrew Nourish		Andrew Nourish				0	0	Eddy Trivett
49	48	11/7/21 13:39	Andrew Nourish	186.83		Sam Bateman		Sam Bateman				0	0	Sabrina Haque-Amin
50	49	11/7/21 13:32	Sam Bateman	109.9		Julian Seifert		Julian Seifert				0	0	Kate Tulloch
51	50	11/7/21 13:32	Julian Seifert	64.9		Luke Burnett		Luke Burnett				0	0	Konrad Stanczyk
Sheet36

Cell Formulas
Range	Formula
F2:F209	F2	=FILTER(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),IFNA(XMATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),UNIQUE(FILTER(C2:C500,B2:B500<TODAY()-7)),0),0)=0)
G2:G7	G2	=FILTER(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),IFNA(XMATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))),0),0)>0)
H2:H209	H2	=FILTER(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),IFNA(XMATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-366))),0),0)=0)
I2	I2	=FILTER(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),L2#>0)
J2:J7	J2	=FILTER(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),M2#>0)
L2:L215	L2	=IFNA(MATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),FILTER(UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))),COUNTIFS(N2#,UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))))>1),0),0)
M2:M215	M2	=IFNA(MATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),FILTER(UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))),COUNTIFS(N2#,UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))))=1),0),0)
N2:N284	N2	=FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))
Dynamic array formulas.

 

[Mandeep23]

Amazing! Although I don't know how its done aha. What formula did you use to convert the date to the right format?
The last two criteria will be hardest to work out. Would you be able to explain what you have done to get the results please?

 

[Mandeep23]

Welcome to the forum.\

Could you please re-post that data after you re-format the date column so that the each cell is an official Excel Date Serial number? Like: 11/7/2021 14:51

Thank you, I'm having trouble converting the date as well

 

[Mandeep23]

Welcome to the forum.\

Could you please re-post that data after you re-format the date column so that the each cell is an official Excel Date Serial number? Like: 11/7/2021 14:51

Hi, I managed to change the date!! Please see the below.

Data.xlsx
	A	B	C	D
1	Order	Ordered Date	Name	Total
2	1	07/11/2021	Ann Vicens-Morton	104.9
3	2	07/11/2021	David Yates	364.8
4	3	07/11/2021	Aisha Patel	104
5	4	07/11/2021	frankie o'shea	74.95
6	5	07/11/2021	Tracy Pickles	139.85
7	6	07/11/2021	John Braid	91.88
8	7	07/11/2021	Marc Gilly	114.85
9	8	07/11/2021	Jeremy Kirk	110
10	9	07/11/2021	Jonathan Pearson	120.6
11	10	07/11/2021	K Fowler	125.9
12	11	07/11/2021	JOHN GRIMMETT	124.85
13	12	07/11/2021	Joe Kemm	145.8
14	13	07/11/2021	Anthony Yaskin	140
15	14	07/11/2021	Mark Downing	102.44
16	15	07/11/2021	Aaron Denton	186.9
17	16	07/11/2021	Sam Hurrell-wills	70.05
18	17	07/11/2021	Elaine Campbell	204.95
19	18	07/11/2021	Cameron Troops	31.85
20	19	07/11/2021	Lyndsay Traherne-Williams	64.9
21	20	07/11/2021	Gareth Lawrence	80
22	21	07/11/2021	Jade Pennick	39.8
23	22	07/11/2021	Sam Horner	105.8
24	23	07/11/2021	Robert Tarn	103.75
25	24	07/11/2021	Tahir Riaz	203.15
26	25	07/11/2021	Toby Miller	161.85
27	26	07/11/2021	Annmarie Wilson	106.6
28	27	07/11/2021	Chris Teasdale	84.95
29	28	07/11/2021	Joss Gale	148.95
30	29	07/11/2021	Noel Wallenberg	120.85
31	30	07/11/2021	Matt thomas	109.9
32	31	07/11/2021	edward richert	242.9
33	32	07/11/2021	Michael de Vyver	93.85
34	33	07/11/2021	Hayden Foster	149.95
35	34	07/11/2021	Arthur Hamilton	124.85
36	35	07/11/2021	Ronan Gilbert	109.9
37	36	07/11/2021	Yvonne Jacobs	114.95
38	37	07/11/2021	Matthew Li Kam Wa	113.85
39	38	07/11/2021	Rod Love	108.75
40	39	07/11/2021	margaret Hone	85.56
41	40	07/11/2021	Raiyan Awan	154.46
42	41	07/11/2021	Peter Murty	64.9
43	42	07/11/2021	Debbie Taylor	80.64
44	43	07/11/2021	Peter Blemings	84.68
45	44	07/11/2021	federico cincotta	130.75
46	45	07/11/2021	alastair Conway	119.95
47	46	07/11/2021	Tom Sirett	161.5
48	47	07/11/2021	Robert Thomas	110.8
49	48	07/11/2021	Andrew Nourish	186.83
50	49	07/11/2021	Sam Bateman	109.9
51	50	07/11/2021	Julian Seifert	64.9
52	51	07/11/2021	Luke Burnett	110.8
53	52	07/11/2021	Charles Fraser	64.9
54	53	07/11/2021	Laurence Herzberg	139.76
55	54	07/11/2021	Lorna Earley	102.7
56	55	07/11/2021	TONY WELLS	212.75
57	56	07/11/2021	PETER EARDLEY	120
58	57	07/11/2021	jack bithell	77.87
59	58	07/11/2021	Sarah-jane Legge	54.9
60	59	07/11/2021	Paul Edwards	138.48
61	60	07/11/2021	Mark James	89.95
62	61	07/11/2021	michael ansell	114.95
63	62	07/11/2021	Aidan Sinclair	123.8
64	63	07/11/2021	Vera Mutimer	163.85
65	64	07/11/2021	Iain Marr	64.9
66	65	07/11/2021	steve moloney	64.95
67	66	07/11/2021	Chris Baker	58.85
68	67	07/11/2021	Scott Big on beauty	64.9
69	68	06/11/2021	EMMA XIE	69.9
70	69	06/11/2021	Loutfig Murfitt	59.9
71	70	06/11/2021	Jan Hoong Ho	111.9
72	71	06/11/2021	Rob Torres	83.92
73	72	06/11/2021	IVAN WOODHOUSE	299.5
74	73	06/11/2021	paul turner	283.95
75	74	06/11/2021	Kay Leach	107.96
76	75	06/11/2021	Wladyslaw Tabis	109.9
77	76	06/11/2021	Marcus Hennessey	140
78	77	06/11/2021	Emily Ridley	39.9
79	78	06/11/2021	Steve Hance	123.9475
80	79	06/11/2021	Henry Worth	49.9
81	80	06/11/2021	Mike Difrancesco	66.63
82	81	06/11/2021	Jonathan Desler	100
83	82	06/11/2021	Roxanne Smith	69.95
84	83	06/11/2021	Fran Martinez	74.95
85	84	06/11/2021	Simeonas Kozemiakinas	299.95
86	85	06/11/2021	Jayson Soriano	121.51
87	86	06/11/2021	Andy O’Boyle	104.85
88	87	06/11/2021	ian kendal	99.33
89	88	06/11/2021	Michael Leung	80
90	89	06/11/2021	Kaylum Ball	80
91	90	06/11/2021	Chris Sheridan	110
92	91	06/11/2021	Gunay Oksar	118
93	92	06/11/2021	Gunay Oksar	100
94	93	05/11/2021	Yoan Wong	321.9
95	94	05/11/2021	Gavin Walley	100
96	95	05/11/2021	Ahmed Omran	79.85
97	96	05/11/2021	Dean Rochester	115.65
98	97	05/11/2021	Graham peel	59.9
99	98	05/11/2021	Andrew Saville	143.85
100	99	05/11/2021	Jon Curtis	39.9
101	100	05/11/2021	Omar Paracha	130.7
102	101	05/11/2021	Simon Kirby	80
103	102	05/11/2021	Penny Cawley	0
104	103	05/11/2021	Mark Green	110.5
105	104	05/11/2021	Kwok Lee	118.85
106	105	05/11/2021	Simon Hurst	140
107	106	05/11/2021	David Cox	159.8
108	107	05/11/2021	Jackie Barton	91.8
109	108	05/11/2021	John Warren	165
110	109	05/11/2021	Anton Richter	669.95
111	110	05/11/2021	Jonathan Truman	100
112	111	05/11/2021	Ciaran Clemmow	180
113	112	05/11/2021	Lily Wong	80
114	113	05/11/2021	James Gilruth	319.95
115	114	05/11/2021	Svava Davies	50
116	115	05/11/2021	Wai Tung Lam	113.52
117	116	05/11/2021	Matthew Marsden	263.5
118	117	05/11/2021	Ellie Lott	69.9
119	118	05/11/2021	simon evans	80
120	119	05/11/2021	Mandy Ireland	45.8
121	120	05/11/2021	Abdur Gearay	57.75
122	121	05/11/2021	Satnam Gill	259.95
123	122	05/11/2021	John Dutton	144.95
124	123	05/11/2021	Michael McGill	114.9
125	124	05/11/2021	Imran Qureshi	165.59
126	125	05/11/2021	Deborah Hamlyn	79.75
127	126	05/11/2021	Howard Grant	300
128	127	05/11/2021	Miguel Perez Guerra	845
129	128	05/11/2021	Dan Beimborn	80
130	129	05/11/2021	miranda rowland	69.9
131	130	05/11/2021	Shelley Watson	50.85
132	131	05/11/2021	Monica Font Del Amo	160
133	132	05/11/2021	Rosanne Ching	80
134	133	04/11/2021	Pierluigi Chiusolo	80
135	134	04/11/2021	Darrell Pinkney	245.55
136	135	04/11/2021	Simon O'Brien	124.9
137	136	04/11/2021	Nick Munday	54.95
138	137	04/11/2021	Jon Rokk	80
139	138	04/11/2021	Sean Pedrosa	80
140	139	04/11/2021	Alen Corak	100
141	140	04/11/2021	Henry Maria	212.75
142	141	04/11/2021	Michel Frey	74.95
143	142	04/11/2021	Niall Maher	80
144	143	04/11/2021	Benjamin Gill	80
145	144	04/11/2021	Vic Wei	80
146	145	04/11/2021	Robert Saunders	80
147	146	04/11/2021	Giovanni Scarcelli	105.46
148	147	04/11/2021	Alan Newton	80
149	148	04/11/2021	Gideon Holdway	61.85
150	149	04/11/2021	Tom Barker	97.8
151	150	04/11/2021	Tom Barker	94.9
152	151	04/11/2021	Josh Harcourt	165.9
153	152	04/11/2021	Georgios Becatoros	319.9
154	153	04/11/2021	Julian Evans	50.7
155	154	04/11/2021	Giles Forster	220
156	155	04/11/2021	denis artunse	380
157	156	04/11/2021	Douglas McMahon	29.9
158	157	04/11/2021	Dr. M.S. Amin	104.85
159	158	04/11/2021	Simon Ward	131.55
160	159	04/11/2021	Sam Cunningham-king	59.9
161	160	04/11/2021	ZANONE GIANCARLO	154.95
162	161	04/11/2021	David Wood	0
163	162	04/11/2021	Ercan Gurlek	104.85
164	163	04/11/2021	Hasan Hashwani	279.65
165	164	04/11/2021	ANDREW MCMASTER	79.95
166	165	04/11/2021	Jon Bentley	0
167	166	04/11/2021	MICHAEL lawson	103.96
168	167	04/11/2021	Philip Chi Ho	152.75
169	168	04/11/2021	Michael Roberts	0
170	169	04/11/2021	Alex Wisbey	65.12
171	170	04/11/2021	Gavin Rowlands	27.9
172	171	04/11/2021	Marta Lima	263.5
173	172	04/11/2021	Lauren Cloud	69.85
174	173	04/11/2021	Sean Phillips	34.95
175	174	04/11/2021	Paul Argent	69.85
176	175	04/11/2021	Anam Choudrey	64.8
177	176	03/11/2021	Juan Carlos Gallardo	109.75
178	177	03/11/2021	Khadeja Nayed	39.9
179	178	03/11/2021	Roberto Barcellona	139.95
180	179	03/11/2021	Chris Roberts	169.9
181	180	03/11/2021	joel loader	55.85
182	181	03/11/2021	Stephen Cotterill	89.95
183	182	03/11/2021	Andrew Derbyshire	44.9
184	183	03/11/2021	Matthew Hepworth	89.95
185	184	03/11/2021	Carlos De Aniceto	124.85
186	185	03/11/2021	Edward Davies	129.67
187	186	03/11/2021	Mike Wort	109.95
188	187	03/11/2021	Paul Atherton	90
189	188	03/11/2021	Mark Telford	69.85
190	189	03/11/2021	Vanessa Hetherington	84.8
191	190	03/11/2021	Stacey Leigh Spalding	103.96
192	191	03/11/2021	Peter Sheath	0
193	192	03/11/2021	Neil White	320
194	193	03/11/2021	Andrew Jefferies	100
195	194	03/11/2021	Paul Klaiber	108.95
196	195	03/11/2021	shaun gibson	130
197	196	03/11/2021	DARREN BLAKE	119.65
198	197	03/11/2021	Garry Smith	104.9
199	198	03/11/2021	June Li	247.88
200	199	03/11/2021	Martin Miller	116.9
201	200	03/11/2021	oscar stevenson	89.95
202	201	03/11/2021	Jamie Eagell	198
203	202	03/11/2021	Jonathan Rivers	0
204	203	03/11/2021	Chris Wiggins	97.12
205	204	03/11/2021	Chris Socratous	120
206	205	03/11/2021	Umair Saeed	199.95
207	206	03/11/2021	Maureen Bennett	0
208	207	03/11/2021	Jas Rajasansir	46.85
209	208	03/11/2021	Nick Day	49.9
210	209	03/11/2021	Akeel Karim	111.88
211	210	03/11/2021	Tony Yuill	29.9
212	211	03/11/2021	Andrew Smellie	139.95
213	212	03/11/2021	andrew murrin	79.95
214	213	03/11/2021	Sylvia Chai	225.9
215	214	03/11/2021	Tim Tharratt	94.95
216	215	03/11/2021	Carl Kirby	100.75
217	216	03/11/2021	SHAMEEL SUHAIL	51.9
218	217	02/11/2021	Werda Botan	59.85
219	218	02/11/2021	Angeline Heffer	283.72
220	219	02/11/2021	Andrew Steel	125
221	220	02/11/2021	Barry Haggerty	160
222	221	02/11/2021	Yiling Zhu	80
223	222	02/11/2021	Ryan Nicholls	89.95
224	223	02/11/2021	Angela Garner	144.95
225	224	02/11/2021	Ioannis Tanes	160
226	225	02/11/2021	Pavel Dubrouski	355.79
227	226	02/11/2021	Rhys Jones	117.9
228	227	02/11/2021	Justin Mycroft	99.95
229	228	02/11/2021	Paul McDermid	101.58
230	229	02/11/2021	SAVA TIHOV	199.12
231	230	02/11/2021	Ryan Goff	44.9
232	231	02/11/2021	Victoria Hatch	113
233	232	02/11/2021	Paul White	110.85
234	233	02/11/2021	Daniel Mclaughlin	109.95
235	234	02/11/2021	Mandy Davis	107.95
236	235	02/11/2021	alun dyde	124.85
237	236	02/11/2021	Rachel Guest	181.36
238	237	02/11/2021	Tom Byford	116.95
239	238	02/11/2021	MD Belal	258.9
240	239	02/11/2021	Amir Sayes	57.07
241	240	02/11/2021	Antonio Munoz Bailey	157.17
242	241	02/11/2021	Graham Beales	219.85
243	242	02/11/2021	David Amber	84.9
244	243	02/11/2021	Suleyman Simsek	60.83
245	244	02/11/2021	Spencer Riddle	114.95
246	245	02/11/2021	M MOROS	108
247	246	02/11/2021	David Williams	174.65
248	247	02/11/2021	Connor Mchugh	79.95
249	248	02/11/2021	christopher busby	60.8
250	249	02/11/2021	Jackie Farrands	61.95
251	250	02/11/2021	David Blair	101.85
252	251	02/11/2021	Lorna Willgress	100.52
253	252	02/11/2021	Farouq Sheikh	359.04
254	253	02/11/2021	Lucas Rocha	83.7
255	254	02/11/2021	M Ahmed	19.95
256	255	02/11/2021	Nick Goodfellow	104.9
257	256	02/11/2021	Paul Richardson	119.95
258	257	02/11/2021	Przemyslaw Krajcer	107.95
259	258	02/11/2021	kingsleigh hammond	153.85
260	259	02/11/2021	Shohib Tariq	130
261	260	02/11/2021	Abraham DAHAN BENAIM	182.92
262	261	02/11/2021	David Armstrong	106.7
263	262	02/11/2021	Calli Amiras	112.25
264	263	02/11/2021	Eddy Trivett	130
265	264	02/11/2021	Sabrina Haque-Amin	102.8
266	265	02/11/2021	Kate Tulloch	38.9
267	266	02/11/2021	Konrad Stanczyk	49.9
268	267	02/11/2021	Paul Ashcroft	55
269	268	02/11/2021	Darren Fairweather	49.85
270	269	02/11/2021	Sarah Burgess	102.85
271	270	02/11/2021	Yinka Okunade	159.9
272	271	02/11/2021	Nigel Neath	0
273	272	02/11/2021	samuel smith	253.65
274	273	02/11/2021	Ben Halleybone	49.9
275	274	02/11/2021	Rachel Denning	176.8
276	275	02/11/2021	Jayne Ankers	107.55
277	276	02/11/2021	Tristram Allen	450
278	277	02/11/2021	Chris Socratous	89.75
279	278	02/11/2021	Rob Linton	100.85
280	279	02/11/2021	Carol Petrie	169.9
281	280	02/11/2021	Robert Gunn	39.9
282	281	02/11/2021	Jimmy Jones	144.95
283	282	02/11/2021	Iain Russell	84.8
284	283	02/11/2021	Luke Cameron	109.9
285	284	02/11/2021	Daniel Chen	104.35
286	285	01/11/2021	Peter Arch	95.8
287	286	01/11/2021	Daniel Hadley	59.9
288	287	01/11/2021	CRISTIAN FRANKIC	119.8
289	288	01/11/2021	Mohsen Mansouri	104.85
290	289	01/11/2021	Daniel Quiney	121.9
291	290	01/11/2021	christine mills	64.95
292	291	01/11/2021	Joanne Bradbury	80
293	292	01/11/2021	Ahmed Abdel-Jaber	139.75
294	293	01/11/2021	Shayla Ali	35.41
295	294	01/11/2021	Miguel Segarra	167.84
296	295	01/11/2021	Jeff Yuen	136
297	296	01/11/2021	Stephen Neale	112.9
298	297	01/11/2021	Sharon Lai	80
299	298	01/11/2021	Richard Collins	104.9
300	299	01/11/2021	Allison Ward	99.75
301	300	01/11/2021	Ewen Scott	43.8
302	301	01/11/2021	David Jackson	156.48
303	302	01/11/2021	Zeshan Alam	100
304	303	01/11/2021	B Chowdhury	41.85
305	304	01/11/2021	Ali Dhanji	259.95
306	305	01/11/2021	Robert Tarn	80
307	306	01/11/2021	Rudy Kathiravel	117.99
308	307	01/11/2021	Anna Deacon	827.04
309	308	01/11/2021	Ahmed Aboushelbaya	287.6
310	309	01/11/2021	Matthew David Gibbs	67.43
311	310	01/11/2021	Graham Allison	130.85
312	311	01/11/2021	ANN MARTIN	146.8
313	312	01/11/2021	mobeen ahmed	111.96
314	313	01/11/2021	Shabeena Maricar	108.8
315	314	01/11/2021	Adam Iqbal	49.85
316	315	01/11/2021	Shaheen Choudhry	118.65
317	316	01/11/2021	Alan Rudkin	114.67
318	317	01/11/2021	David Roberts	80
319	318	01/11/2021	Zohaib Siddiqui	119.85
320	319	01/11/2021	Robert Soultanaev	89.95
321	320	01/11/2021	Alex Nitka	49.85
322	321	01/11/2021	Robert Pickstock	72.7
323	322	01/11/2021	Imran Chohan	452.65
324	323	01/11/2021	P White	29.9
325	324	01/11/2021	Patricia Clements	49.95
326	325	01/11/2021	David Nolte	143.45
327	326	01/11/2021	Niall McKinney	155.3
328	327	01/11/2021	Ahmed Rawi	105.7
329	328	01/11/2021	Muhammad Hussain	59.85
330	329	01/11/2021	Geoff Brewis-Levie	29.9
331	330	01/11/2021	Mikhail Hessin	120
332	331	01/11/2021	Mark Rowe	29.9
333	332	01/11/2021	Andrew Mills	80
334	333	01/11/2021	Gerry Duffey	102.9
335	334	01/11/2021	Ejaz Ahmed	109.95
336	335	01/11/2021	Croz Croswell	93.75
337	336	01/11/2021	Simon Lace	29.9
338	337	01/11/2021	Gary Morris	100
339	338	01/11/2021	Leonardo Gonzalez	70.8
340	339	01/11/2021	Chris Branscombe Ling	116.95
341	340	01/11/2021	Gary Harrison	29.9
342	341	01/11/2021	Gary Morris	184.95
343	342	01/11/2021	carl mccaffrey	49.85
344	343	01/11/2021	Athif Hussain	128.75
345	344	01/11/2021	Elizabeth Mitchell	49.85
346	345	01/11/2021	Mohamed Hanif Omar	89.9
347	346	01/11/2021	Andrew Lucas	90
348	347	01/11/2021	Hugh Orange	102.95
349	348	01/11/2021	Zayba Sheikh	49.85
350	349	01/11/2021	David Charlesworth	115
351	350	01/11/2021	John Head	80
352	351	01/11/2021	Paul Elliott	250
353	352	01/11/2021	Heinz Forster	120
354	353	01/11/2021	Austin Straub	35.85
355	354	01/11/2021	Matthew Miller	1239.9
356	355	01/11/2021	Aidan Lundy	123.21
357	356	01/11/2021	James Joyce	144.95
358	357	01/11/2021	Paul Graham	80
359	358	01/11/2021	Sara Wells	164.01
360	359	01/11/2021	Karveh Cavalirie	60.9
361	360	01/11/2021	Patrick Mooney	139.95
362	361	01/11/2021	Robert Worters	185.95
363	362	01/11/2021	Danielle Graham	49.91
364	363	01/11/2021	Suryan Wirya Simunovic	80
365	364	01/11/2021	John Winder	89.95
366	365	01/11/2021	Simon Sankey	114.95
367	366	01/11/2021	David Benfell	60.8
368	367	01/11/2021	Toby Rainbow	164.95
369	368	01/11/2021	Graham Lewis	69.95
370	369	01/11/2021	Jobe Ferguson	80
371	370	01/11/2021	Amir Iqbal	159.85
372	371	01/11/2021	Sarah Elhatow-Senkuviene	61.87
373	372	01/11/2021	Giles Stafford	114.95
374	373	01/11/2021	Sahal Bhamjee	100
375	374	01/11/2021	Jonathan McCrory	100
376	375	01/11/2021	Niall Stack	41.91
377	376	01/11/2021	Ori Reiss	182.75
378	377	01/11/2021	Marion Buchan	100
379	378	01/11/2021	Peter Davies	0
380	379	01/11/2021	Chris Ansell	0
381	380	01/11/2021	Lee Starmer	0
382	381	01/11/2021	Nick March	0
383	382	01/11/2021	M Ahmed	110.42
384	383	01/11/2021	Stanley Davies	89.04
385	384	01/11/2021	Peter Kwok	340
386	385	01/11/2021	Gareth Lazell	199.8
387	386	01/11/2021	Simon Fletcher	89.0471
388	387	01/11/2021	Garry Moore	69.85
389	388	01/11/2021	Toby Topcott	174.85
390	389	01/11/2021	Philip Tucker	125
391	390	01/11/2021	Tak Chi Choy	108.7
392	391	31/10/2021	Wayne Forster	113.9
393	392	31/10/2021	Omar Al-Haffar	70.8
394	393	31/10/2021	vincent masnou	123.17
395	394	31/10/2021	David Hill	109.9
396	395	31/10/2021	Ed Farrell	74.95
397	396	31/10/2021	Ignacio Farga Ninoles	101.85
398	397	31/10/2021	Ian Anderson	65.9
399	398	31/10/2021	Thomas Simmons	37.75
400	399	31/10/2021	Daniel Taylor	103.85
401	400	31/10/2021	Jon Bentley	532.87
402	401	31/10/2021	Claudiu Tirsolea	109.9
403	402	31/10/2021	Jeremy Cooke	240
404	403	31/10/2021	Alison Porter	105.8
405	404	31/10/2021	Julie Mahmoud	100
406	405	31/10/2021	Hoa Huynh	59.9
407	406	31/10/2021	Darren Clarke	110.85
408	407	31/10/2021	ALUN MARRIOTT	61.8
409	408	31/10/2021	Saif Alomani	39.9
410	409	31/10/2021	Temuulen Nanzad	87.8
411	410	31/10/2021	Roger Taslaq	146.9
412	411	31/10/2021	Phil Bird	20.9
413	412	31/10/2021	Paul Cerisola	44.9
414	413	31/10/2021	Dimitrios Skopelitis	760
415	414	31/10/2021	Liz Glover	50.85
416	415	31/10/2021	Angela Bird	110.85
417	416	31/10/2021	Melissa Shaw	101.56
418	417	31/10/2021	Munadia Lauria	182.75
419	418	31/10/2021	Rob Lovelock	92.85
420	419	31/10/2021	John Harrhy	69.95
421	420	31/10/2021	Andy Gosheron	71.8
422	421	31/10/2021	Stephen Hamer	96.8583
423	422	31/10/2021	Dawn von Bergen	120
424	423	31/10/2021	Maryam ALI	39.9
425	424	31/10/2021	Daniel Drinkwater	54.95
426	425	31/10/2021	RUSSELL KINGSNORTH	180
427	426	31/10/2021	Glen Binns	130
428	427	31/10/2021	Patrik Burstrom	113.75
429	428	31/10/2021	Gareth Keegan	132
430	429	31/10/2021	Anthony Walters	135
431	430	31/10/2021	Isa Mohammed	60.95
432	431	31/10/2021	polina zabelina	150
433	432	31/10/2021	Shakera Tayub	170
434	433	31/10/2021	Grant Read	69.95
435	434	31/10/2021	carl mccaffrey	69.85
436	435	31/10/2021	Andrew Parraco	113.8
437	436	31/10/2021	Susan Clarke	55.75
438	437	31/10/2021	Mark Harris	158.95
439	438	31/10/2021	Jon Rokk	101.7
440	439	31/10/2021	Ian Roberts	69.95
441	440	31/10/2021	Mandy Dunn	152.6
442	441	31/10/2021	Sami Agush	69.95
443	442	31/10/2021	fraser crichton	69.95
444	443	31/10/2021	Yi Yang	134.95
445	444	31/10/2021	Tatiana Livesey	320.9
446	445	31/10/2021	Jared Tovee	63.4
447	446	31/10/2021	matthew Francis	43.4
448	447	31/10/2021	Y Nazir	89.85
449	448	31/10/2021	H Suggate	69.85
450	449	31/10/2021	Martin McNally	89.95
451	450	30/10/2021	Arshad Waheed	243.8
452	451	30/10/2021	Fay Gao	249.8
453	452	30/10/2021	David Mensik	179.95
454	453	30/10/2021	Helen Brownlees	68.9
455	454	30/10/2021	Brendon Jiang	164.85
456	455	30/10/2021	Juliet O'Mahony	172.86
457	456	30/10/2021	Ross Lynam-Carter	80
458	457	30/10/2021	James Silber	104.75
459	458	30/10/2021	Simon Cotmore	100
460	459	30/10/2021	Simon Inchley	122.95
461	460	30/10/2021	Tracy Lower	85.91
462	461	30/10/2021	Joe Hankin	115.95
463	462	30/10/2021	Emma Fish	103.95
464	463	30/10/2021	Gareth Lewis	154.95
465	464	30/10/2021	GEORGE DIAMOND	180
466	465	30/10/2021	Richard Claypole	106.86
467	466	30/10/2021	Angela Scattergood	30.85
468	467	30/10/2021	Paul Allan	80
469	468	30/10/2021	Trisha Campbell	85
470	469	30/10/2021	Stephen Smith	100.8
471	470	30/10/2021	Rob FLOYD	130
472	471	30/10/2021	Nick March	80
473	472	30/10/2021	Abdul Mehmood	189.95
474	473	30/10/2021	geoff hayllar	104.75
475	474	30/10/2021	Nick Ekendahl	161.38
476	475	30/10/2021	Ilya Belyaev	100
477	476	30/10/2021	David Carr	71.25
478	477	30/10/2021	Jonathan Wilkinson	128.95
479	478	30/10/2021	Xin Jiang	114.9
480	479	30/10/2021	P J White	110
481	480	30/10/2021	Julie Mahmoud	100
482	481	30/10/2021	LAI LIU	149.85
483	482	30/10/2021	peter sheath	49.95
484	483	29/10/2021	Shane Duffield	128.19
485	484	29/10/2021	Oliver Webb	218.2
486	485	29/10/2021	Del Flint	102.75
487	486	29/10/2021	George Tebbutt	86.45
488	487	29/10/2021	Laurel Powers-Freeling	62.5
489	488	29/10/2021	Rasheed Mosaheb	109.95
490	489	29/10/2021	craig renilson	120
491	490	29/10/2021	Amardeep Chima	80
492	491	29/10/2021	Dr. M.S. Amin	119.85
493	492	29/10/2021	Nic Lee	180
494	493	29/10/2021	Julie Mahmoud	110
495	494	29/10/2021	sajid khaliq	69.8
496	495	29/10/2021	Jason Nowell	215.85
497	496	29/10/2021	Daniel Goldfarb	48.8
498	497	29/10/2021	gavin hutcheson	69.8
499	498	29/10/2021	Guy Keng	95.8
500	499	29/10/2021	FIONA SAVORY	116.74
501	500	29/10/2021	Andy Wheatley-Rae	120.9
502	501	29/10/2021	Randall Stransky	120
503	502	29/10/2021	Nigel Grant	60.6274
504	503	29/10/2021	Helen Irving	50
505	504	29/10/2021	philipp sjostrom	214.32
506	505	29/10/2021	Suzanne Osman	69.83
507	506	29/10/2021	Oran Barak	0
508	507	29/10/2021	Lee Stolworthy	127.29
509	508	29/10/2021	Bashar Al-Damen	120
510	509	29/10/2021	Gary Hilton	109.8
511	510	29/10/2021	Max Card	52.8583
512	511	29/10/2021	Ben Watson	63.25
513	512	29/10/2021	andrev pukstys	103.9
514	513	29/10/2021	Najib Murad	159.55
515	514	29/10/2021	Agnieszka Spychalska	111.2
516	515	29/10/2021	Reece Morgan	93.46
517	516	29/10/2021	Matt Stent	95.9
518	517	29/10/2021	Lan Tan	114.95
519	518	28/10/2021	Mark Brown	102.9
520	519	28/10/2021	Ashley Grewal	594.9
521	520	28/10/2021	Andrew Sutcliffe	174.95
522	521	28/10/2021	Andrew Skinner	294.9
523	522	28/10/2021	Gemma Cuff	45.85
524	523	28/10/2021	Damian Johnson	560.83
525	524	28/10/2021	Razvan Carata	101.92
526	525	28/10/2021	Ian Roberts	69.95
527	526	28/10/2021	Sophie Blair	34.9
528	527	28/10/2021	Marcin Maslowski	123.17
529	528	28/10/2021	Penny Leonard	50
530	529	28/10/2021	Jessica Crews	29.95
531	530	28/10/2021	Craig Davies	210
532	531	28/10/2021	Shane Reeves	84.9
533	532	28/10/2021	Jonathan O Toole	203.8
534	533	28/10/2021	Mary Trussler	49.9
535	534	28/10/2021	Ben Hopkins	95.84
536	535	28/10/2021	Adam Barnie	167.88
537	536	28/10/2021	Janice Kohut	110
538	537	28/10/2021	Kenton Simms	11.95
539	538	28/10/2021	Guy Orr	279.9
540	539	28/10/2021	Diego Rivera	89.17
541	540	28/10/2021	Huw Jones	144.95
542	541	28/10/2021	greg krieger	79.95
543	542	28/10/2021	Andrew Lazarou	111.85
544	543	28/10/2021	Kenton Simms	51.85
545	544	28/10/2021	Farouq Sheikh	415
546	545	27/10/2021	oscar stevenson	59.9
547	546	27/10/2021	Rupert Shield	116.95
548	547	27/10/2021	Rogier Graeve	354.95
549	548	27/10/2021	Hasna Kahlalech	107.85
550	549	27/10/2021	Darren Shiels	342.995
551	550	27/10/2021	Chris Knight	332.28
552	551	27/10/2021	Daniel Cowan	48.8
553	552	27/10/2021	aaron probert	96.78
554	553	27/10/2021	Lee Starmer	155.47
555	554	27/10/2021	Matthew Green	87.96
556	555	27/10/2021	Lawrence Wareham	129.95
557	556	27/10/2021	Gideon Holdway	59.47
558	557	27/10/2021	Arran Hill	44.9
559	558	27/10/2021	David Armstrong	129.6
560	559	27/10/2021	Tim Burrows	27.9
561	560	27/10/2021	Glen Bagshaw	44.9
562	561	27/10/2021	PAT HULME	90
563	562	27/10/2021	Gerald Donegan	214
564	563	27/10/2021	Farhana Nabi	69.95
565	564	27/10/2021	Rafik Bedair	104.85
566	565	27/10/2021	Will Edwards	164.95
567	566	27/10/2021	Christopher Waites	114.67
568	567	27/10/2021	Asad Khalil	70.8
569	568	27/10/2021	The Dude	204.8083
570	569	27/10/2021	Paul Morrison	120
571	570	27/10/2021	Kevin Hassell	85
572	571	27/10/2021	Dimitri Vvedensky	37.75
573	572	27/10/2021	Govinda Chana	180
574	573	27/10/2021	shahid patel	170
575	574	27/10/2021	Andy George	220
576	575	27/10/2021	Steven Mulrain	54.9
577	576	27/10/2021	Constantine Folkes	93.46
578	577	27/10/2021	Victoria Browning	135
579	578	27/10/2021	Martyn Harrison	79.95
580	579	27/10/2021	Mustafa Terzi	179.85
581	580	27/10/2021	Nick March	271.92
582	581	27/10/2021	John Young	139.88
583	582	26/10/2021	Ian McManus	100.7
584	583	26/10/2021	Naoko Boys	64.9
585	584	26/10/2021	Jeffrey Lee	60
586	585	26/10/2021	Robert McGregor	50
587	586	26/10/2021	Amina Begum	95.88
588	587	26/10/2021	Steve Fisher	64.9
589	588	26/10/2021	Daniel Edwards	200
590	589	26/10/2021	Chelmen Liwen Chang	100.6
591	590	26/10/2021	Matt Harrington	109.9
592	591	26/10/2021	Graham Hogan	59.9
593	592	26/10/2021	Paul Cooper	109.85
594	593	26/10/2021	dao phung	104.85
595	594	26/10/2021	Darryn ****aday	139.75
596	595	26/10/2021	Sebastian Orton	88.28
597	596	26/10/2021	Damien Jackman	60.95
598	597	26/10/2021	Danny Wood	104.9
599	598	26/10/2021	Alex Basmas	206.24
600	599	26/10/2021	Darren Rowlands	127.6
601	600	26/10/2021	Christina Holloway	152.65
Sheet3

 

[JamesCanale]

Amazing! Although I don't know how its done aha. What formula did you use to convert the date to the right format?
The last two criteria will be hardest to work out. Would you be able to explain what you have done to get the results please?

When I construct this kind of thing, I'll make 'bite sized' columns of data that do some of the subtasks, but always with dynamic array formulas (with the # operator) so I can reconstruct it into one formula at the end. I couldn't figure out why columns I and J weren't allowing that to work correctly. Here is my spreadsheet showing those extra columns and how they were used. It gets complex and isn't easy to explain, but maybe easier to show my work:

MrExcelPlayground4.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Order	Ordered Date	Name	Total		New customers in the last week	Customers in the last week that ordered at least once in the previous 6 months	Customers in the last week that haven't ordered in the last 12 months prior	Customers in the last week that ordered more than once in the previous 6 months	Customers in the last week that ordered exactly once in the previous 6 months		More than once	exactly once	People ordering more than 7 days, but less than 181		Ordered in the last week:	Ordered more than 1 week ago	match of people ordering this week and if they ordered in the prior 6 months
2	1	11/7/21 22:13	Ann Vicens-Morton	104.9		Ann Vicens-Morton	Robert Tarn	Ann Vicens-Morton	#CALC!	Robert Tarn		0	0	Pierluigi Chiusolo	Ann Vicens-Morton	Ann Vicens-Morton	Pierluigi Chiusolo	0	1		Jon Rokk	Pierluigi Chiusolo	Pierluigi Chiusolo
3	2	11/7/21 21:15	David Yates	364.8		David Yates		David Yates				0	0	Darrell Pinkney	David Yates	David Yates	Darrell Pinkney	0	1		Tom Barker	Darrell Pinkney	Darrell Pinkney
4	3	11/7/21 21:09	Aisha Patel	104		Aisha Patel		Aisha Patel				0	0	Simon O'Brien	Aisha Patel	Aisha Patel	Simon O'Brien	0	1		Dr. M.S. Amin	Simon O'Brien	Simon O'Brien
5	4	11/7/21 21:01	frankie o'shea	74.95		frankie o'shea		frankie o'shea				0	0	Nick Munday	frankie o'shea	frankie o'shea	Nick Munday	0	1		Jon Bentley	Nick Munday	Nick Munday
6	5	11/7/21 20:35	Tracy Pickles	139.85		Tracy Pickles		Tracy Pickles				0	0	Jon Rokk	Tracy Pickles	Tracy Pickles	Jon Rokk	0	2		Peter Sheath	Sean Pedrosa	Jon Rokk
7	6	11/7/21 20:10	John Braid	91.88		John Braid		John Braid				0	0	Sean Pedrosa	John Braid	John Braid	Sean Pedrosa	0	1		Chris Socratous	Alen Corak	Sean Pedrosa
8	7	11/7/21 19:53	Marc Gilly	114.85		Marc Gilly		Marc Gilly				0	0	Alen Corak	Marc Gilly	Marc Gilly	Alen Corak	0	1		M Ahmed	Henry Maria	Alen Corak
9	8	11/7/21 19:50	Jeremy Kirk	110		Jeremy Kirk		Jeremy Kirk				0	0	Henry Maria	Jeremy Kirk	Jeremy Kirk	Henry Maria	0	1		Gary Morris	Michel Frey	Henry Maria
10	9	11/7/21 19:38	Jonathan Pearson	120.6		Jonathan Pearson		Jonathan Pearson				0	0	Michel Frey	Jonathan Pearson	Jonathan Pearson	Michel Frey	0	1		carl mccaffrey	Niall Maher	Michel Frey
11	10	11/7/21 19:24	K Fowler	125.9		K Fowler		K Fowler				0	0	Niall Maher	K Fowler	K Fowler	Niall Maher	0	1		Nick March	Benjamin Gill	Niall Maher
12	11	11/7/21 19:20	JOHN GRIMMETT	124.85		JOHN GRIMMETT		JOHN GRIMMETT				0	0	Benjamin Gill	JOHN GRIMMETT	JOHN GRIMMETT	Benjamin Gill	0	1		Julie Mahmoud	Vic Wei	Benjamin Gill
13	12	11/7/21 18:52	Joe Kemm	145.8		Joe Kemm		Joe Kemm				0	0	Vic Wei	Joe Kemm	Joe Kemm	Vic Wei	0	1			Robert Saunders	Vic Wei
14	13	11/7/21 18:51	Anthony Yaskin	140		Anthony Yaskin		Anthony Yaskin				0	0	Robert Saunders	Anthony Yaskin	Anthony Yaskin	Robert Saunders	0	1			Giovanni Scarcelli	Robert Saunders
15	14	11/7/21 18:50	Mark Downing	102.44		Mark Downing		Mark Downing				0	0	Giovanni Scarcelli	Mark Downing	Mark Downing	Giovanni Scarcelli	0	1			Alan Newton	Giovanni Scarcelli
16	15	11/7/21 18:46	Aaron Denton	186.9		Aaron Denton		Aaron Denton				0	0	Alan Newton	Aaron Denton	Aaron Denton	Alan Newton	0	1			Gideon Holdway	Alan Newton
17	16	11/7/21 18:45	Sam Hurrell-wills	70.05		Sam Hurrell-wills		Sam Hurrell-wills				0	0	Gideon Holdway	Sam Hurrell-wills	Sam Hurrell-wills	Gideon Holdway	0	1			Josh Harcourt	Gideon Holdway
18	17	11/7/21 18:43	Elaine Campbell	204.95		Elaine Campbell		Elaine Campbell				0	0	Tom Barker	Elaine Campbell	Elaine Campbell	Tom Barker	0	2			Georgios Becatoros	Tom Barker
19	18	11/7/21 18:32	Cameron Troops	31.85		Cameron Troops		Cameron Troops				0	0	Tom Barker	Cameron Troops	Cameron Troops	Josh Harcourt	0	1			Julian Evans	Tom Barker
20	19	11/7/21 18:23	Lyndsay Traherne-Williams	64.9		Lyndsay Traherne-Williams		Lyndsay Traherne-Williams				0	0	Josh Harcourt	Lyndsay Traherne-Williams	Lyndsay Traherne-Williams	Georgios Becatoros	0	1			Giles Forster	Josh Harcourt
21	20	11/7/21 17:59	Gareth Lawrence	80		Gareth Lawrence		Gareth Lawrence				0	0	Georgios Becatoros	Gareth Lawrence	Gareth Lawrence	Julian Evans	0	1			denis artunse	Georgios Becatoros
22	21	11/7/21 17:46	Jade Pennick	39.8		Jade Pennick		Jade Pennick				0	0	Julian Evans	Jade Pennick	Jade Pennick	Giles Forster	0	1			Douglas McMahon	Julian Evans
23	22	11/7/21 17:36	Sam Horner	105.8		Sam Horner		Sam Horner				0	0	Giles Forster	Sam Horner	Sam Horner	denis artunse	0	1			Simon Ward	Giles Forster
24	23	11/7/21 17:31	Robert Tarn	103.75		Tahir Riaz		Tahir Riaz				0	164	denis artunse	Tahir Riaz	Robert Tarn	Douglas McMahon	171	1			Sam Cunningham-king	denis artunse
25	24	11/7/21 17:01	Tahir Riaz	203.15		Toby Miller		Toby Miller				0	0	Douglas McMahon	Toby Miller	Tahir Riaz	Dr. M.S. Amin	0	2			ZANONE GIANCARLO	Douglas McMahon
Sheet36

Cell Formulas
Range	Formula
F2:F131	F2	=FILTER(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),IFNA(XMATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),UNIQUE(FILTER(C2:C500,B2:B500<TODAY()-7)),0),0)=0)
G2	G2	=FILTER(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),IFNA(XMATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))),0),0)>0)
H2:H131	H2	=FILTER(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),IFNA(XMATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-366))),0),0)=0)
I2	I2	=FILTER(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),L2#>0)
J2	J2	=FILTER(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),M2#>0)
L2:L132	L2	=IFNA(MATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),FILTER(UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))),COUNTIFS(N2#,UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))))>1),0),0)
M2:M132	M2	=IFNA(MATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),FILTER(UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))),COUNTIFS(N2#,UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))))=1),0),0)
N2:N368	N2	=FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))
O2:O131	O2	=FILTER(P2#,R2#=0)
P2:P132	P2	=UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7))
Q2:Q356	Q2	=UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181)))
R2:R132	R2	=IFNA(XMATCH(UNIQUE(FILTER(C2:C500,B2:B500>=TODAY()-7)),UNIQUE(FILTER(C2:C500,B2:B500<TODAY()-7)),0),0)
S2:S356	S2	=COUNTIFS(N2#,Q2#)
U2:U12	U2	=FILTER(UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))),COUNTIFS(W2#,UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))))>1)
V2:V345	V2	=FILTER(Q2#,S2#=1)
W2:W368	W2	=FILTER(C2:C500,B2:B500<TODAY()-7,UNIQUE(FILTER(C2:C500,(B2:B500<TODAY()-7)*(B2:B500>TODAY()-181))))
Dynamic array formulas.