How many rows between each data point in a column

[William53]

Hi All
I have been trying to grapple with the following problem for a few hours over the last few weeks. I have a list of weekly shopping amounts for the last 8/9 years. I have created a list of unique costs and then counted those to give me an idea of what is the most cost etc. What I want to do is count the weeks or rows between each cost. So, if it £90 in week 1, how many weeks or rows did £90 appear again throughout the data set?
I have tried to modify this formula "=LET(rowdiffs,FILTER(ROW(E2:E900)-1,E2:E900<>"")-FILTER(ROW(E1:E900),E1:E900<>""),INDEX(rowdiffs,SEQUENCE(ROWS(rowdiffs)-1)))", which was given to me by another forum member (KRice) to solve a football problem which worked when counting blank cells between entries, but cannot seem to get the same results if I ask for a specific amount like the £90 problem.
I have attached most of the data set but not all due to limit.

Goods Cost.xlsx
	A	B	C	D
2	Date	Total Cost	Sorted Unique	Times Spent
3	13-Feb-04	£ 154.00	45	1
4	20-Feb-04	£ 156.00	46	1
5	27-Feb-04	£ 119.00	51	1
6	5-Mar-04	£ 120.00	52	1
7	12-Mar-04	£ 158.00	56	2
8	19-Mar-04	£ 193.00	57	3
9	26-Mar-04	£ 83.00	60	2
10	2-Apr-04	£ 103.00	61	2
11	9-Apr-04	£ 57.00	62	1
12	16-Apr-04	£ 132.00	64	1
13	23-Apr-04	£ 131.00	66	1
14	30-Apr-04	£ 77.00	67	2
15	7-May-04	£ 126.00	68	1
16	14-May-04	£ 96.00	69	1
17	21-May-04	£ 169.00	70	6
18	28-May-04	£ 137.00	71	2
19	4-Jun-04	£ 139.00	72	2
20	11-Jun-04	£ 74.00	74	9
21	18-Jun-04	£ 136.00	75	4
22	25-Jun-04	£ 123.00	76	2
23	2-Jul-04	£ 113.00	77	5
24	9-Jul-04	£ 82.00	79	3
25	16-Jul-04	£ 169.00	80	3
26	23-Jul-04	£ 109.00	81	7
27	30-Jul-04	£ 125.00	82	4
28	6-Aug-04	£ 123.00	83	9
29	13-Aug-04	£ 181.00	84	6
30	20-Aug-04	£ 87.00	85	5
31	27-Aug-04	£ 106.00	86	7
32	3-Sep-04	£ 83.00	87	5
33	10-Sep-04	£ 137.00	88	7
34	17-Sep-04	£ 142.00	89	6
35	24-Sep-04	£ 166.00	90	2
36	1-Oct-04	£ 146.00	91	5
37	8-Oct-04	£ 87.00	92	7
38	15-Oct-04	£ 137.00	93	7
39	22-Oct-04	£ 98.00	94	4
40	29-Oct-04	£ 114.00	95	6
41	5-Nov-04	£ 141.00	96	11
42	12-Nov-04	£ 72.00	97	9
43	19-Nov-04	£ 119.00	98	7
44	26-Nov-04	£ 99.00	99	6
45	3-Dec-04	£ 118.00	100	10
46	10-Dec-04	£ 76.00	101	11
47	17-Dec-04	£ 151.00	102	15
48	24-Dec-04	£ 100.00	103	11
49	31-Dec-04	£ 111.00	104	7
50	7-Jan-05	£ 150.00	105	4
51	14-Jan-05	£ 79.00	106	10
52	21-Jan-05	£ 86.00	107	13
53	28-Jan-05	£ 142.00	108	8
54	4-Feb-05	£ 90.00	109	12
55	11-Feb-05	£ 131.00	110	7
56	18-Feb-05	£ 145.00	111	12
57	25-Feb-05	£ 147.00	112	11
58	4-Mar-05	£ 144.00	113	18
59	11-Mar-05	£ 126.00	114	13
60	18-Mar-05	£ 159.00	115	7
61	25-Mar-05	£ 141.00	116	10
62	1-Apr-05	£ 183.00	117	8
63	8-Apr-05	£ 124.00	118	10
64	15-Apr-05	£ 145.00	119	13
65	22-Apr-05	£ 97.00	120	15
66	29-Apr-05	£ 128.00	121	10
67	6-May-05	£ 110.00	122	10
68	13-May-05	£ 132.00	123	22
69	20-May-05	£ 101.00	124	8
70	27-May-05	£ 155.00	125	14
71	3-Jun-05	£ 89.00	126	11
72	10-Jun-05	£ 129.00	127	5
73	17-Jun-05	£ 61.00	128	16
74	24-Jun-05	£ 88.00	129	12
75	1-Jul-05	£ 85.00	130	5
76	8-Jul-05	£ 208.00	131	16
77	15-Jul-05	£ 89.00	132	23
78	22-Jul-05	£ 155.00	133	11
79	29-Jul-05	£ 147.00	134	15
80	5-Aug-05	£ 86.00	135	13
81	12-Aug-05	£ 145.00	136	9
82	19-Aug-05	£ 136.00	137	15
83	26-Aug-05	£ 154.00	138	11
84	2-Sep-05	£ 114.00	139	18
85	9-Sep-05	£ 120.00	140	8
86	16-Sep-05	£ 103.00	141	10
87	23-Sep-05	£ 139.00	142	15
88	30-Sep-05	£ 162.00	143	15
89	7-Oct-05	£ 106.00	144	10
90	14-Oct-05	£ 83.00	145	14
91	21-Oct-05	£ 96.00	146	10
92	28-Oct-05	£ 191.00	147	12
93	4-Nov-05	£ 179.00	148	11
94	11-Nov-05	£ 150.00	149	10
95	18-Nov-05	£ 142.00	150	6
96	25-Nov-05	£ 120.00	151	10
97	2-Dec-05	£ 83.00	152	8
98	9-Dec-05	£ 144.00	153	4
99	16-Dec-05	£ 70.00	154	10
100	23-Dec-05	£ 161.00	155	12
101	30-Dec-05	£ 131.00	156	9
102	6-Jan-06	£ 57.00	157	8
103	13-Jan-06	£ 106.00	158	11
104	20-Jan-06	£ 154.00	159	11
105	27-Jan-06	£ 134.00	160	6
106	3-Feb-06	£ 149.00	161	12
107	10-Feb-06	£ 147.00	162	8
108	17-Feb-06	£ 115.00	163	7
109	24-Feb-06	£ 96.00	164	3
110	3-Mar-06	£ 70.00	165	4
111	10-Mar-06	£ 149.00	166	4
112	17-Mar-06	£ 176.00	167	4
113	24-Mar-06	£ 160.00	168	3
114	31-Mar-06	£ 149.00	169	6
115	7-Apr-06	£ 148.00	170	1
116	14-Apr-06	£ 160.00	171	7
117	21-Apr-06	£ 126.00	173	4
118	28-Apr-06	£ 87.00	174	3
119	5-May-06	£ 92.00	176	5
120	12-May-06	£ 132.00	177	1
121	19-May-06	£ 116.00	178	2
122	26-May-06	£ 125.00	179	6
123	2-Jun-06	£ 131.00	180	1
124	9-Jun-06	£ 103.00	181	4
125	16-Jun-06	£ 109.00	182	4
126	23-Jun-06	£ 147.00	183	4
127	30-Jun-06	£ 120.00	184	2
128	7-Jul-06	£ 112.00	185	2
129	14-Jul-06	£ 92.00	187	1
130	21-Jul-06	£ 103.00	188	1
131	28-Jul-06	£ 95.00	189	1
132	4-Aug-06	£ 88.00	190	2
133	11-Aug-06	£ 179.00	191	2
134	18-Aug-06	£ 178.00	192	2
135	25-Aug-06	£ 173.00	193	3
136	1-Sep-06	£ 130.00	194	2
137	8-Sep-06	£ 88.00	197	2
138	15-Sep-06	£ 107.00	199	2
139	22-Sep-06	£ 163.00	200	1
140	29-Sep-06	£ 52.00	201	1
141	6-Oct-06	£ 111.00	202	1
142	13-Oct-06	£ 138.00	208	1
143	20-Oct-06	£ 155.00	212	1
144	27-Oct-06	£ 109.00	217	1
145	3-Nov-06	£ 141.00	0
146	10-Nov-06	£ 128.00
147	17-Nov-06	£ 135.00
148	24-Nov-06	£ 95.00
149	1-Dec-06	£ 106.00
150	8-Dec-06	£ 134.00
151	15-Dec-06	£ 146.00
152	22-Dec-06	£ 121.00
153	29-Dec-06	£ 77.00
154	5-Jan-07	£ 146.00
155	12-Jan-07	£ 77.00
156	19-Jan-07	£ 120.00
157	26-Jan-07	£ 117.00
158	2-Feb-07	£ 130.00
159	9-Feb-07	£ 142.00
160	16-Feb-07	£ 136.00
161	23-Feb-07	£ 77.00
162	2-Mar-07	£ 139.00
163	9-Mar-07	£ 121.00
164	16-Mar-07	£ 143.00
165	23-Mar-07	£ 118.00
166	30-Mar-07	£ 132.00
167	6-Apr-07	£ 156.00
168	13-Apr-07	£ 131.00
169	20-Apr-07	£ 167.00
170	27-Apr-07	£ 132.00
171	4-May-07	£ 144.00
172	11-May-07	£ 123.00
173	18-May-07	£ 185.00
174	25-May-07	£ 179.00
175	1-Jun-07	£ 148.00
176	8-Jun-07	£ 103.00
177	15-Jun-07	£ 87.00
178	22-Jun-07	£ 100.00
179	29-Jun-07	£ 126.00
180	6-Jul-07	£ 108.00
181	13-Jul-07	£ 116.00
182	20-Jul-07	£ 132.00
183	27-Jul-07	£ 96.00
184	3-Aug-07	£ 151.00
185	10-Aug-07	£ 197.00
186	17-Aug-07	£ 98.00
187	24-Aug-07	£ 110.00
188	31-Aug-07	£ 106.00
189	7-Sep-07	£ 114.00
190	14-Sep-07	£ 87.00
191	21-Sep-07	£ 122.00
192	28-Sep-07	£ 165.00
193	5-Oct-07	£ 137.00
194	12-Oct-07	£ 182.00
195	19-Oct-07	£ 134.00
196	26-Oct-07	£ 148.00
197	2-Nov-07	£ 96.00
198	9-Nov-07	£ 102.00
199	16-Nov-07	£ 120.00
200	23-Nov-07	£ 111.00
201	30-Nov-07	£ 119.00
202	7-Dec-07	£ 129.00
203	14-Dec-07	£ 143.00
204	21-Dec-07	£ 125.00
205	28-Dec-07	£ 139.00
206	4-Jan-08	£ 112.00
207	11-Jan-08	£ 167.00
208	18-Jan-08	£ 139.00
209	25-Jan-08	£ 81.00
210	1-Feb-08	£ 193.00
211	8-Feb-08	£ 157.00
212	15-Feb-08	£ 159.00
213	22-Feb-08	£ 159.00
214	29-Feb-08	£ 185.00
215	7-Mar-08	£ 75.00
216	14-Mar-08	£ 142.00
217	21-Mar-08	£ 88.00
218	28-Mar-08	£ 99.00
219	4-Apr-08	£ 126.00
220	11-Apr-08	£ 156.00
221	18-Apr-08	£ 93.00
222	25-Apr-08	£ 106.00
223	2-May-08	£ 158.00
224	9-May-08	£ 144.00
225	16-May-08	£ 93.00
226	23-May-08	£ 92.00
227	30-May-08	£ 95.00
228	6-Jun-08	£ 137.00
229	13-Jun-08	£ 160.00
230	20-Jun-08	£ 137.00
231	27-Jun-08	£ 145.00
232	4-Jul-08	£ 123.00
233	11-Jul-08	£ 89.00
234	18-Jul-08	£ 113.00
235	25-Jul-08	£ 86.00
236	1-Aug-08	£ 138.00
237	8-Aug-08	£ 85.00
238	15-Aug-08	£ 103.00
239	22-Aug-08	£ 152.00
240	29-Aug-08	£ 123.00
241	5-Sep-08	£ 91.00
242	12-Sep-08	£ 162.00
243	19-Sep-08	£ 100.00
244	26-Sep-08	£ 144.00
245	3-Oct-08	£ 97.00
246	10-Oct-08	£ 113.00
247	17-Oct-08	£ 117.00
248	24-Oct-08	£ 100.00
249	31-Oct-08	£ 121.00
250	7-Nov-08	£ 57.00
251	14-Nov-08	£ 79.00
252	21-Nov-08	£ 143.00
253	28-Nov-08	£ 101.00
254	5-Dec-08	£ 113.00
255	12-Dec-08	£ 140.00
256	19-Dec-08	£ 193.00
257	26-Dec-08	£ 123.00
258	2-Jan-09	£ 180.00
259	9-Jan-09	£ 120.00
260	16-Jan-09	£ 141.00
261	23-Jan-09	£ 190.00
262	30-Jan-09	£ 148.00
263	6-Feb-09	£ 136.00
264	13-Feb-09	£ 173.00
265	20-Feb-09	£ 96.00
266	27-Feb-09	£ 140.00
267	6-Mar-09	£ 109.00
268	13-Mar-09	£ 140.00
269	20-Mar-09	£ 117.00
270	27-Mar-09	£ 174.00
271	3-Apr-09	£ 124.00
272	10-Apr-09	£ 122.00
273	17-Apr-09	£ 123.00
274	24-Apr-09	£ 104.00
275	1-May-09	£ 140.00
276	8-May-09	£ 111.00
277	15-May-09	£ 107.00
278	22-May-09	£ 107.00
279	29-May-09	£ 121.00
280	5-Jun-09	£ 131.00
281	12-Jun-09	£ 120.00
282	19-Jun-09	£ 86.00
283	26-Jun-09	£ 107.00
284	3-Jul-09	£ 177.00
285	10-Jul-09	£ 130.00
286	17-Jul-09	£ 109.00
287	24-Jul-09	£ 136.00
288	31-Jul-09	£ 81.00
289	7-Aug-09	£ 107.00
290	14-Aug-09	£ 116.00
291	21-Aug-09	£ 100.00
292	28-Aug-09	£ 171.00
293	4-Sep-09	£ 112.00
294	11-Sep-09	£ 147.00
295	18-Sep-09	£ 131.00
296	25-Sep-09	£ 96.00
297	2-Oct-09	£ 142.00
298	9-Oct-09	£ 143.00
299	16-Oct-09	£ 143.00
300	23-Oct-09	£ 104.00
301	30-Oct-09	£ 155.00
302	6-Nov-09	£ 152.00
303	13-Nov-09	£ 111.00
304	20-Nov-09	£ 132.00
305	27-Nov-09	£ 74.00
306	4-Dec-09	£ 136.00
307	11-Dec-09	£ 194.00
308	18-Dec-09	£ 160.00
309	25-Dec-09	£ 74.00
310	1-Jan-10	£ 118.00
311	8-Jan-10	£ 113.00
312	15-Jan-10	£ 165.00
313	22-Jan-10	£ 133.00
314	29-Jan-10	£ 138.00
315	5-Feb-10	£ 192.00
316	12-Feb-10	£ 107.00
317	19-Feb-10	£ 161.00
318	26-Feb-10	£ 107.00
319	5-Mar-10	£ 141.00
320	12-Mar-10	£ 142.00
321	19-Mar-10	£ 145.00
322	26-Mar-10	£ 122.00
323	2-Apr-10	£ 125.00
324	9-Apr-10	£ 119.00
325	16-Apr-10	£ 103.00
326	23-Apr-10	£ 107.00
327	30-Apr-10	£ 113.00
328	7-May-10	£ 77.00
329	14-May-10	£ 139.00
330	21-May-10	£ 144.00
331	28-May-10	£ 109.00
332	4-Jun-10	£ 137.00
333	11-Jun-10	£ 128.00
334	18-Jun-10	£ 132.00
335	25-Jun-10	£ 86.00
336	2-Jul-10	£ 148.00
337	9-Jul-10	£ 158.00
338	16-Jul-10	£ 217.00
339	23-Jul-10	£ 135.00
340	30-Jul-10	£ 85.00
341	6-Aug-10	£ 137.00
342	13-Aug-10	£ 96.00
343	20-Aug-10	£ 145.00
344	27-Aug-10	£ 99.00
345	3-Sep-10	£ 159.00
346	10-Sep-10	£ 159.00
347	17-Sep-10	£ 161.00
348	24-Sep-10	£ 109.00
349	1-Oct-10	£ 86.00
350	8-Oct-10	£ 159.00
351	15-Oct-10	£ 150.00
352	22-Oct-10	£ 68.00
353	29-Oct-10	£ 132.00
354	5-Nov-10	£ 167.00
355	12-Nov-10	£ 125.00
356	19-Nov-10	£ 140.00
357	26-Nov-10	£ 163.00
358	3-Dec-10	£ 133.00
359	10-Dec-10	£ 94.00
360	17-Dec-10	£ 129.00
361	24-Dec-10	£ 181.00
362	31-Dec-10	£ 141.00
363	7-Jan-11	£ 153.00
364	14-Jan-11	£ 123.00
365	21-Jan-11	£ 66.00
366	28-Jan-11	£ 143.00
367	4-Feb-11	£ 119.00
368	11-Feb-11	£ 83.00
369	18-Feb-11	£ 114.00
370	25-Feb-11	£ 160.00
371	4-Mar-11	£ 132.00
372	11-Mar-11	£ 143.00
373	18-Mar-11	£ 110.00
374	25-Mar-11	£ 99.00
375	1-Apr-11	£ 97.00
376	8-Apr-11	£ 179.00
377	15-Apr-11	£ 111.00
378	22-Apr-11	£ 162.00
379	29-Apr-11	£ 159.00
380	6-May-11	£ 97.00
381	13-May-11	£ 120.00
382	20-May-11	£ 111.00
383	27-May-11	£ 128.00
384	3-Jun-11	£ 182.00
385	10-Jun-11	£ 127.00
386	17-Jun-11	£ 114.00
387	24-Jun-11	£ 112.00
388	1-Jul-11	£ 119.00
389	8-Jul-11	£ 137.00
390	15-Jul-11	£ 138.00
391	22-Jul-11	£ 141.00
392	29-Jul-11	£ 133.00
393	5-Aug-11	£ 111.00
394	12-Aug-11	£ 101.00
395	19-Aug-11	£ 95.00
396	26-Aug-11	£ 137.00
397	2-Sep-11	£ 157.00
398	9-Sep-11	£ 119.00
399	16-Sep-11	£ 108.00
400	23-Sep-11	£ 135.00
401	30-Sep-11	£ 123.00
402	7-Oct-11	£ 158.00
403	14-Oct-11	£ 143.00
404	21-Oct-11	£ 137.00
405	28-Oct-11	£ 142.00
406	4-Nov-11	£ 159.00
407	11-Nov-11	£ 76.00
408	18-Nov-11	£ 123.00
409	25-Nov-11	£ 121.00
410	2-Dec-11	£ 147.00
411	9-Dec-11	£ 153.00
412	16-Dec-11	£ 71.00
413	23-Dec-11	£ 102.00
414	30-Dec-11	£ 189.00
415	6-Jan-12	£ 60.00
416	13-Jan-12	£ 114.00
417	20-Jan-12	£ 89.00
418	27-Jan-12	£ 125.00
419	3-Feb-12	£ 108.00
420	10-Feb-12	£ 97.00
421	17-Feb-12	£ 128.00
422	24-Feb-12	£ 82.00
423	2-Mar-12	£ 96.00
424	9-Mar-12	£ 157.00
425	16-Mar-12	£ 92.00
426	23-Mar-12	£ 128.00
427	30-Mar-12	£ 126.00
428	6-Apr-12	£ 141.00
429	13-Apr-12	£ 129.00
430	20-Apr-12	£ 111.00
431	27-Apr-12	£ 156.00
432	4-May-12	£ 149.00
433	11-May-12	£ 113.00
434	18-May-12	£ 182.00
435	25-May-12	£ 164.00
436	1-Jun-12	£ 82.00
437	8-Jun-12	£ 112.00
438	15-Jun-12	£ 145.00
439	22-Jun-12	£ 143.00
440	29-Jun-12	£ 127.00
441	6-Jul-12	£ 183.00
442	13-Jul-12	£ 132.00
443	20-Jul-12	£ 146.00
444	27-Jul-12	£ 121.00
445	3-Aug-12	£ 181.00
446	10-Aug-12	£ 147.00
447	17-Aug-12	£ 149.00
448	24-Aug-12	£ 79.00
449	31-Aug-12	£ 156.00
450	7-Sep-12	£ 135.00
451	14-Sep-12	£ 107.00
452	21-Sep-12	£ 141.00
453	28-Sep-12	£ 132.00
454	5-Oct-12	£ 83.00
455	12-Oct-12	£ 108.00
456	19-Oct-12	£ 166.00
457	26-Oct-12	£ 85.00
458	2-Nov-12	£ 74.00
459	9-Nov-12	£ 132.00
460	16-Nov-12	£ 108.00
461	23-Nov-12	£ 81.00
462	30-Nov-12	£ 115.00
463	7-Dec-12	£ 117.00
464	14-Dec-12	£ 133.00
465	21-Dec-12	£ 112.00
466	28-Dec-12	£ 143.00
467	4-Jan-13	£ 104.00
468	11-Jan-13	£ 133.00
469	18-Jan-13	£ 126.00
470	25-Jan-13	£ 99.00
471	1-Feb-13	£ 135.00
472	8-Feb-13	£ 112.00
473	15-Feb-13	£ 98.00
474	22-Feb-13	£ 132.00
475	1-Mar-13	£ 119.00
476	8-Mar-13	£ 116.00
477	15-Mar-13	£ 102.00
478	22-Mar-13	£ 154.00
479	29-Mar-13	£ 176.00
480	5-Apr-13	£ 100.00
481	12-Apr-13	£ 103.00
482	19-Apr-13	£ 145.00
483	26-Apr-13	£ 129.00
484	3-May-13	£ 131.00
485	10-May-13	£ 161.00
486	17-May-13	£ 125.00
487	24-May-13	£ 113.00
488	31-May-13	£ 161.00
489	7-Jun-13	£ 142.00
490	14-Jun-13	£ 171.00
491	21-Jun-13	£ 132.00
492	28-Jun-13	£ 126.00
493	5-Jul-13	£ 92.00
494	12-Jul-13	£ 151.00
495	19-Jul-13	£ 114.00
496	26-Jul-13	£ 151.00
497	2-Aug-13	£ 184.00
498	9-Aug-13	£ 67.00
499	16-Aug-13	£ 147.00
500	23-Aug-13	£ 100.00
501	30-Aug-13	£ 125.00
502	6-Sep-13	£ 128.00
503	13-Sep-13	£ 84.00
504	20-Sep-13	£ 134.00
505	27-Sep-13	£ 148.00
506	4-Oct-13	£ 135.00
507	11-Oct-13	£ 101.00
508	18-Oct-13	£ 159.00
509	25-Oct-13	£ 84.00
510	1-Nov-13	£ 118.00
511	8-Nov-13	£ 168.00
512	15-Nov-13	£ 102.00
513	22-Nov-13	£ 154.00
514	29-Nov-13	£ 85.00
515	6-Dec-13	£ 88.00
516	13-Dec-13	£ 101.00
517	20-Dec-13	£ 107.00
518	27-Dec-13	£ 70.00
Bought Goods

Cell Formulas
Range	Formula
C3:C145	C3	=SORT(UNIQUE(B3:B991))
D3:D144	D3	=COUNTIF($B$3:$B$991,C3)
Dynamic array formulas.

 

[Fluff]

How about

=LET(a,FILTER(ROW($B$3:$B$1000),($B$3:$B$1000=C3)*(C3<>0),""),IF(ROWS(a)=1,0,TEXTJOIN(", ",,DROP(a,1)-DROP(a,-1))))

 

[William53]

Hi Fluff
Wow it works but I haven't got a clue how!! Never heard of DROP.
Thank you so much for your time, really is appreciated.

 

[Fluff]

You're welcome & thanks for the feedback.