Find repeating numbers in a column

[will20fitz]

Hi there,

I have a series of planetary degree data for about 50 years.

What i would like to do is to take the first degree data for each planet and then calc the period of days which each planet takes to come back round to the same degree.

For example, Venus starts at 296.17 degrees and then takes 325 days to come back round to 296.86 degrees then 410 days to come back round to 296.39 degrees.

Obviously each planet degree does not conform to an exact decimal degree. How do i take acount of this in any calculations?!

Can anyone help?

Many thanks,

WIll

Enter Date	Sun Degree	Moon Degree	Mercury Degree	Venus Degree
13/2/1974	324.7670263	229.0303842	341.7334639	296.1668176
14/2/1974	325.7775648	241.3656592	342.0482524	296.1945601
15/2/1974	326.7877808	253.428917	342.1915536	296.2620978
16/2/1974	327.7976617	265.3102858	342.1606254	296.3685934
17/2/1974	328.8071934	277.0961467	341.9562621	296.5131229
18/2/1974	329.8163601	288.8642333	341.5832378	296.6946953
19/2/1974	330.8251452	300.6803714	341.0506086	296.9122691
20/2/1974	331.8335311	312.5965815	340.3718125	297.1647672
21/2/1974	332.8414995	324.6505167	339.5645124	297.4510887
22/2/1974	333.8490313	336.8663429	338.6501495	297.7701202
23/2/1974	334.8561064	349.2571807	337.6532015	298.1207451
24/2/1974	335.8627038	1.829003221	336.6001883	298.5018526
25/2/1974	336.8688022	14.58543061	335.5185062	298.9123458
26/2/1974	337.8743805	27.53243142	334.4352065	299.3511487
27/2/1974	338.8794188	40.68175608	333.3758432	299.8172128
28/2/1974	339.8838993	54.05196531	332.363505	300.3095218
1/3/1974	340.8878079	67.66612523	331.4181096	300.8270948
2/3/1974	341.8911345	81.54572587	330.5559969	301.3689885
3/3/1974	342.8938745	95.70120258	329.7898086	301.9342964
4/3/1974	343.8960285	110.1205374	329.1286135	302.5221482
5/3/1974	344.8976024	124.7587778	328.5782131	303.1317065
6/3/1974	345.8986066	139.5326373	328.1415605	303.7621637
7/3/1974	346.899055	154.3244275	327.8192336	304.4127386
8/3/1974	347.8989639	168.9969664	327.6099111	305.0826731
9/3/1974	348.8983497	183.4162169	327.5108205	305.7712299
10/3/1974	349.8972284	197.4742888	327.5181363	306.4776906
11/3/1974	350.8956138	211.1052853	327.6273182	307.2013552
12/3/1974	351.8935169	224.2903905	327.833389	307.9415423
13/3/1974	352.8909451	237.0534898	328.1311553	308.69759
14/3/1974	353.8879025	249.4513682	328.5153759	309.4688569
15/3/1974	354.8843898	261.5624787	328.9808885	310.2547238
16/3/1974	355.8804048	273.4767492	329.5226991	311.054594
17/3/1974	356.8759429	285.2873103	330.1360439	311.8678945
18/3/1974	357.8709976	297.0840271	330.8164283	312.6940754
19/3/1974	358.8655605	308.9483362	331.5596485	313.5326102
20/3/1974	359.8596219	320.9489831	332.3617996	314.3829944
21/3/1974	0.8531703289	333.1385775	333.2192752	315.2447453
22/3/1974	1.846192952	345.5512486	334.1287595	316.1174009
23/3/1974	2.83867513	358.2019764	335.087216	317.0005194
24/3/1974	3.830600709	11.0882284	336.091874	317.8936793
25/3/1974	4.821952291	24.19415205	337.140214	318.7964795
26/3/1974	5.812711843	37.49678012	338.2299536	319.7085397
27/3/1974	6.80286156	50.97285848	339.3590324	320.6295007
28/3/1974	7.792384957	64.60443076	340.5255984	321.5590252
29/3/1974	8.781268055	78.38144904	341.7279931	322.4967973
30/3/1974	9.769500521	92.30038583	342.9647376	323.4425221
31/3/1974	10.75707661	106.3588888	344.234519	324.3959245
1/4/1974	11.74399577	120.5476644	345.5361771	325.3567474
2/4/1974	12.7302628	134.8417858	346.8686925	326.3247494
3/4/1974	13.71588759	149.1943221	348.2311752	327.2997023
4/4/1974	14.70088432	163.5352014	349.6228546	328.2813881
5/4/1974	15.68527045	177.7770417	351.0430706	329.2695968
6/4/1974	16.66906541	191.8272507	352.4912645	330.2641239
7/4/1974	17.65228929	205.603059	353.9669715	331.2647692
8/4/1974	18.6349616	219.0449129	355.4698124	332.2713354
9/4/1974	19.61710028	232.1246423	356.999487	333.2836283
10/4/1974	20.59872107	244.8472869	358.5557674	334.3014559
11/4/1974	21.57983711	257.2477792	0.138491725	335.3246298
12/4/1974	22.56045886	269.384726	1.747558869	336.3529654
13/4/1974	23.54059428	281.3333078	3.382923342	337.3862821
14/4/1974	24.52024897	293.1784932	5.044589759	338.4244044
15/4/1974	25.49942642	305.008978	6.732606762	339.4671616
16/4/1974	26.47812812	316.9117393	8.447059765	340.5143878
17/4/1974	27.45635351	328.966881	10.18806222	341.5659223
18/4/1974	28.4340999	341.2425183	11.95574525	342.6216086
19/4/1974	29.41136225	353.7897769	13.75024556	343.6812951
20/4/1974	30.38813303	6.638465884	15.57169154	344.7448347
21/4/1974	31.3644022	19.79442594	17.42018752	345.8120853
22/4/1974	32.34015748	33.23968583	19.29579556	346.8829105
23/4/1974	33.31538484	46.93614008	21.19851449	347.9571803
24/4/1974	34.29006938	60.83243726	23.12825536	349.0347722
25/4/1974	35.26419641	74.87251718	25.0848129	350.115572
26/4/1974	36.23775269	89.00344174	27.0678328	351.1994743
27/4/1974	37.21072778	103.1803595	29.07677485	352.2863834
28/4/1974	38.1831151	117.3675522	31.11087281	353.3762124
29/4/1974	39.15491285	131.5359346	33.16909207	354.4688833

 

[PeteWright]

The only thing I can think of is defining a fuzziness factor and compare the data against that factor:

Book001.xlsx
	A	B	C	D	E
1	1.23456	TRUE		Value	1.23456
2	1.23467	TRUE		Fuzziness	0.02
3	1.34567	FALSE
4	1.35678	FALSE
5	1.45678	FALSE
6	1.45789	FALSE
7	1.56789	FALSE
8	1.56891	FALSE
9	1.67891	FALSE
10	1.68901	FALSE
11	1.78901	FALSE
12	1.78012	FALSE
13	1.89012	FALSE
14	1.89123	FALSE
15	1.90123	FALSE
16	1.91234	FALSE
17	1.12345	FALSE
18	1.13456	FALSE
19	1.24567	TRUE
20	1.25678	FALSE
Sheet1

Cell Formulas
Range	Formula
B1:B20	B1	=ABS($E$1-A1)<=$E$2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B20	Cell Value	contains "true"	text	NO

 

[SanjayGMusafir]

Since Mercury repeats faster than any other planet, I worked with it. Check this -

Book1
	A	B	C	D	E	F	G	H
1	Enter Date	Sun Degree	Moon Degree	Mercury Degree	Mercury	Repeat	Repeat Date	Venus Degree
2	2/13/74	324.7670263	229.0303842	341.7334639	341	1		296.1668176
3	2/14/74	325.7775648	241.3656592	342.0482524	342	1		296.1945601
4	2/15/74	326.7877808	253.428917	342.1915536	342	2	2/15/74	296.2620978
5	2/16/74	327.7976617	265.3102858	342.1606254	342	3	2/16/74	296.3685934
6	2/17/74	328.8071934	277.0961467	341.9562621	341	2	2/17/74	296.5131229
7	2/18/74	329.8163601	288.8642333	341.5832378	341	3	2/18/74	296.6946953
8	2/19/74	330.8251452	300.6803714	341.0506086	341	4	2/19/74	296.9122691
9	2/20/74	331.8335311	312.5965815	340.3718125	340	1		297.1647672
10	2/21/74	332.8414995	324.6505167	339.5645124	339	1		297.4510887
11	2/22/74	333.8490313	336.8663429	338.6501495	338	1		297.7701202
12	2/23/74	334.8561064	349.2571807	337.6532015	337	1		298.1207451
13	2/24/74	335.8627038	1.829003221	336.6001883	336	1		298.5018526
14	2/25/74	336.8688022	14.58543061	335.5185062	335	1		298.9123458
15	2/26/74	337.8743805	27.53243142	334.4352065	334	1		299.3511487
16	2/27/74	338.8794188	40.68175608	333.3758432	333	1		299.8172128
17	2/28/74	339.8838993	54.05196531	332.363505	332	1		300.3095218
18	3/1/74	340.8878079	67.66612523	331.4181096	331	1		300.8270948
19	3/2/74	341.8911345	81.54572587	330.5559969	330	1		301.3689885
20	3/3/74	342.8938745	95.70120258	329.7898086	329	1		301.9342964
21	3/4/74	343.8960285	110.1205374	329.1286135	329	2	3/4/74	302.5221482
22	3/5/74	344.8976024	124.7587778	328.5782131	328	1		303.1317065
23	3/6/74	345.8986066	139.5326373	328.1415605	328	2	3/6/74	303.7621637
24	3/7/74	346.899055	154.3244275	327.8192336	327	1		304.4127386
25	3/8/74	347.8989639	168.9969664	327.6099111	327	2	3/8/74	305.0826731
26	3/9/74	348.8983497	183.4162169	327.5108205	327	3	3/9/74	305.7712299
27	3/10/74	349.8972284	197.4742888	327.5181363	327	4	3/10/74	306.4776906
28	3/11/74	350.8956138	211.1052853	327.6273182	327	5	3/11/74	307.2013552
29	3/12/74	351.8935169	224.2903905	327.833389	327	6	3/12/74	307.9415423
30	3/13/74	352.8909451	237.0534898	328.1311553	328	3	3/13/74	308.69759
31	3/14/74	353.8879025	249.4513682	328.5153759	328	4	3/14/74	309.4688569
32	3/15/74	354.8843898	261.5624787	328.9808885	328	5	3/15/74	310.2547238
33	3/16/74	355.8804048	273.4767492	329.5226991	329	3	3/16/74	311.054594
34	3/17/74	356.8759429	285.2873103	330.1360439	330	2	3/17/74	311.8678945
35	3/18/74	357.8709976	297.0840271	330.8164283	330	3	3/18/74	312.6940754
36	3/19/74	358.8655605	308.9483362	331.5596485	331	2	3/19/74	313.5326102
37	3/20/74	359.8596219	320.9489831	332.3617996	332	2	3/20/74	314.3829944
38	3/21/74	0.853170329	333.1385775	333.2192752	333	2	3/21/74	315.2447453
39	3/22/74	1.846192952	345.5512486	334.1287595	334	2	3/22/74	316.1174009
40	3/23/74	2.83867513	358.2019764	335.087216	335	2	3/23/74	317.0005194
41	3/24/74	3.830600709	11.0882284	336.091874	336	2	3/24/74	317.8936793
42	3/25/74	4.821952291	24.19415205	337.140214	337	2	3/25/74	318.7964795
43	3/26/74	5.812711843	37.49678012	338.2299536	338	2	3/26/74	319.7085397
44	3/27/74	6.80286156	50.97285848	339.3590324	339	2	3/27/74	320.6295007
45	3/28/74	7.792384957	64.60443076	340.5255984	340	2	3/28/74	321.5590252
46	3/29/74	8.781268055	78.38144904	341.7279931	341	5	3/29/74	322.4967973
47	3/30/74	9.769500521	92.30038583	342.9647376	342	4	3/30/74	323.4425221
48	3/31/74	10.75707661	106.3588888	344.234519	344	1		324.3959245
49	4/1/74	11.74399577	120.5476644	345.5361771	345	1		325.3567474
50	4/2/74	12.7302628	134.8417858	346.8686925	346	1		326.3247494
51	4/3/74	13.71588759	149.1943221	348.2311752	348	1		327.2997023
52	4/4/74	14.70088432	163.5352014	349.6228546	349	1		328.2813881
53	4/5/74	15.68527045	177.7770417	351.0430706	351	1		329.2695968
54	4/6/74	16.66906541	191.8272507	352.4912645	352	1		330.2641239
55	4/7/74	17.65228929	205.603059	353.9669715	353	1		331.2647692
56	4/8/74	18.6349616	219.0449129	355.4698124	355	1		332.2713354
57	4/9/74	19.61710028	232.1246423	356.999487	356	1		333.2836283
58	4/10/74	20.59872107	244.8472869	358.5557674	358	1		334.3014559
59	4/11/74	21.57983711	257.2477792	0.138491725	0	1		335.3246298
60	4/12/74	22.56045886	269.384726	1.747558869	1	1		336.3529654
61	4/13/74	23.54059428	281.3333078	3.382923342	3	1		337.3862821
62	4/14/74	24.52024897	293.1784932	5.044589759	5	1		338.4244044
63	4/15/74	25.49942642	305.008978	6.732606762	6	1		339.4671616
64	4/16/74	26.47812812	316.9117393	8.447059765	8	1		340.5143878
65	4/17/74	27.45635351	328.966881	10.18806222	10	1		341.5659223
66	4/18/74	28.4340999	341.2425183	11.95574525	11	1		342.6216086
67	4/19/74	29.41136225	353.7897769	13.75024556	13	1		343.6812951
68	4/20/74	30.38813303	6.638465884	15.57169154	15	1		344.7448347
69	4/21/74	31.3644022	19.79442594	17.42018752	17	1		345.8120853
70	4/22/74	32.34015748	33.23968583	19.29579556	19	1		346.8829105
71	4/23/74	33.31538484	46.93614008	21.19851449	21	1		347.9571803
72	4/24/74	34.29006938	60.83243726	23.12825536	23	1		349.0347722
73	4/25/74	35.26419641	74.87251718	25.0848129	25	1		350.115572
74	4/26/74	36.23775269	89.00344174	27.0678328	27	1		351.1994743
75	4/27/74	37.21072778	103.1803595	29.07677485	29	1		352.2863834
76	4/28/74	38.1831151	117.3675522	31.11087281	31	1		353.3762124
77	4/29/74	39.15491285	131.5359346	33.16909207	33	1		354.4688833
Sheet1

Cell Formulas
Range	Formula
E2:E77	E2	=TRUNC(D2)
F2:F77	F2	=COUNTIFS($E$2:E2,E2)
G2:G77	G2	=IFS(F2>1,LOOKUP(2,1/(D:D=D2)*(F:F=F2-1),A:A),TRUE,"")

 

[SanjayGMusafir]

Though I didn't get any feedback from your side. Yet, I was worried with the accuracy of results. Try this and revert -

Book1
	A	B	C	D	E	F	G	H	I
1	Enter Date	Sun Degree	Moon Degree	Mercury Degree	Mercury	Repeat	Repeat Date	Diff	Venus Degree
2	2/13/74	324.7670263	229.0303842	341.7334639	341	0			296.1668176
3	2/14/74	325.7775648	241.3656592	342.0482524	342	0			296.1945601
4	2/15/74	326.7877808	253.428917	342.1915536	342	1	2/14/74	1	296.2620978
5	2/16/74	327.7976617	265.3102858	342.1606254	342	2	2/15/74	1	296.3685934
6	2/17/74	328.8071934	277.0961467	341.9562621	341	1	2/13/74	4	296.5131229
7	2/18/74	329.8163601	288.8642333	341.5832378	341	2	2/17/74	1	296.6946953
8	2/19/74	330.8251452	300.6803714	341.0506086	341	3	2/18/74	1	296.9122691
9	2/20/74	331.8335311	312.5965815	340.3718125	340	0			297.1647672
10	2/21/74	332.8414995	324.6505167	339.5645124	339	0			297.4510887
11	2/22/74	333.8490313	336.8663429	338.6501495	338	0			297.7701202
12	2/23/74	334.8561064	349.2571807	337.6532015	337	0			298.1207451
13	2/24/74	335.8627038	1.829003221	336.6001883	336	0			298.5018526
14	2/25/74	336.8688022	14.58543061	335.5185062	335	0			298.9123458
15	2/26/74	337.8743805	27.53243142	334.4352065	334	0			299.3511487
16	2/27/74	338.8794188	40.68175608	333.3758432	333	0			299.8172128
17	2/28/74	339.8838993	54.05196531	332.363505	332	0			300.3095218
18	3/1/74	340.8878079	67.66612523	331.4181096	331	0			300.8270948
19	3/2/74	341.8911345	81.54572587	330.5559969	330	0			301.3689885
20	3/3/74	342.8938745	95.70120258	329.7898086	329	0			301.9342964
21	3/4/74	343.8960285	110.1205374	329.1286135	329	1	3/3/74	1	302.5221482
22	3/5/74	344.8976024	124.7587778	328.5782131	328	0			303.1317065
23	3/6/74	345.8986066	139.5326373	328.1415605	328	1	3/5/74	1	303.7621637
24	3/7/74	346.899055	154.3244275	327.8192336	327	0			304.4127386
25	3/8/74	347.8989639	168.9969664	327.6099111	327	1	3/7/74	1	305.0826731
26	3/9/74	348.8983497	183.4162169	327.5108205	327	2	3/8/74	1	305.7712299
27	3/10/74	349.8972284	197.4742888	327.5181363	327	3	3/9/74	1	306.4776906
28	3/11/74	350.8956138	211.1052853	327.6273182	327	4	3/10/74	1	307.2013552
29	3/12/74	351.8935169	224.2903905	327.833389	327	5	3/11/74	1	307.9415423
30	3/13/74	352.8909451	237.0534898	328.1311553	328	2	3/6/74	7	308.69759
31	3/14/74	353.8879025	249.4513682	328.5153759	328	3	3/13/74	1	309.4688569
32	3/15/74	354.8843898	261.5624787	328.9808885	328	4	3/14/74	1	310.2547238
33	3/16/74	355.8804048	273.4767492	329.5226991	329	2	3/4/74	12	311.054594
34	3/17/74	356.8759429	285.2873103	330.1360439	330	1	3/2/74	15	311.8678945
35	3/18/74	357.8709976	297.0840271	330.8164283	330	2	3/17/74	1	312.6940754
36	3/19/74	358.8655605	308.9483362	331.5596485	331	1	3/1/74	18	313.5326102
37	3/20/74	359.8596219	320.9489831	332.3617996	332	1	2/28/74	20	314.3829944
38	3/21/74	0.853170329	333.1385775	333.2192752	333	1	2/27/74	22	315.2447453
39	3/22/74	1.846192952	345.5512486	334.1287595	334	1	2/26/74	24	316.1174009
40	3/23/74	2.83867513	358.2019764	335.087216	335	1	2/25/74	26	317.0005194
41	3/24/74	3.830600709	11.0882284	336.091874	336	1	2/24/74	28	317.8936793
42	3/25/74	4.821952291	24.19415205	337.140214	337	1	2/23/74	30	318.7964795
43	3/26/74	5.812711843	37.49678012	338.2299536	338	1	2/22/74	32	319.7085397
44	3/27/74	6.80286156	50.97285848	339.3590324	339	1	2/21/74	34	320.6295007
45	3/28/74	7.792384957	64.60443076	340.5255984	340	1	2/20/74	36	321.5590252
46	3/29/74	8.781268055	78.38144904	341.7279931	341	4	2/19/74	38	322.4967973
47	3/30/74	9.769500521	92.30038583	342.9647376	342	3	2/16/74	42	323.4425221
48	3/31/74	10.75707661	106.3588888	344.234519	344	0			324.3959245
49	4/1/74	11.74399577	120.5476644	345.5361771	345	0			325.3567474
50	4/2/74	12.7302628	134.8417858	346.8686925	346	0			326.3247494
51	4/3/74	13.71588759	149.1943221	348.2311752	348	0			327.2997023
52	4/4/74	14.70088432	163.5352014	349.6228546	349	0			328.2813881
53	4/5/74	15.68527045	177.7770417	351.0430706	351	0			329.2695968
54	4/6/74	16.66906541	191.8272507	352.4912645	352	0			330.2641239
55	4/7/74	17.65228929	205.603059	353.9669715	353	0			331.2647692
56	4/8/74	18.6349616	219.0449129	355.4698124	355	0			332.2713354
57	4/9/74	19.61710028	232.1246423	356.999487	356	0			333.2836283
58	4/10/74	20.59872107	244.8472869	358.5557674	358	0			334.3014559
59	4/11/74	21.57983711	257.2477792	0.138491725	0	0			335.3246298
60	4/12/74	22.56045886	269.384726	1.747558869	1	0			336.3529654
61	4/13/74	23.54059428	281.3333078	3.382923342	3	0			337.3862821
62	4/14/74	24.52024897	293.1784932	5.044589759	5	0			338.4244044
63	4/15/74	25.49942642	305.008978	6.732606762	6	0			339.4671616
64	4/16/74	26.47812812	316.9117393	8.447059765	8	0			340.5143878
65	4/17/74	27.45635351	328.966881	10.18806222	10	0			341.5659223
66	4/18/74	28.4340999	341.2425183	11.95574525	11	0			342.6216086
67	4/19/74	29.41136225	353.7897769	13.75024556	13	0			343.6812951
68	4/20/74	30.38813303	6.638465884	15.57169154	15	0			344.7448347
69	4/21/74	31.3644022	19.79442594	17.42018752	17	0			345.8120853
70	4/22/74	32.34015748	33.23968583	19.29579556	19	0			346.8829105
71	4/23/74	33.31538484	46.93614008	21.19851449	21	0			347.9571803
72	4/24/74	34.29006938	60.83243726	23.12825536	23	0			349.0347722
73	4/25/74	35.26419641	74.87251718	25.0848129	25	0			350.115572
74	4/26/74	36.23775269	89.00344174	27.0678328	27	0			351.1994743
75	4/27/74	37.21072778	103.1803595	29.07677485	29	0			352.2863834
76	4/28/74	38.1831151	117.3675522	31.11087281	31	0			353.3762124
77	4/29/74	39.15491285	131.5359346	33.16909207	33	0			354.4688833
Sheet1

Cell Formulas
Range	Formula
E2:E77	E2	=TRUNC(D2)
F2:F77	F2	=COUNTIFS(E$2:E2,E2)-1
G2:G77	G2	=IFS(F2>=1,XLOOKUP(1,(E$2:E2=E2)*(F$2:F2=F2-1),$A$2:$A2),TRUE,"")
H2	H2	=IFS(G2="","",TRUE,$A2-G2)
H3:H77	H3	=IFS(G3="","",TRUE,A3-G3)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H2:H77,F2:F77	Expression	=$F2<>0	text	NO

Tried same on Venus too -

Book1
	I	J	K	L	M	N
1	Venus Degree	Venus	Repeat	Repeat Date	Diff	Enter Date
2	296.1668176	296	0			2/13/74
3	296.1945601	296	1	2/13/74	1	2/14/74
4	296.2620978	296	2	2/14/74	1	2/15/74
5	296.3685934	296	3	2/15/74	1	2/16/74
6	296.5131229	296	4	2/16/74	1	2/17/74
7	296.6946953	296	5	2/17/74	1	2/18/74
8	296.9122691	296	6	2/18/74	1	2/19/74
9	297.1647672	297	0			2/20/74
10	297.4510887	297	1	2/20/74	1	2/21/74
11	297.7701202	297	2	2/21/74	1	2/22/74
12	298.1207451	298	0			2/23/74
13	298.5018526	298	1	2/23/74	1	2/24/74
14	298.9123458	298	2	2/24/74	1	2/25/74
15	299.3511487	299	0			2/26/74
16	299.8172128	299	1	2/26/74	1	2/27/74
17	300.3095218	300	0			2/28/74
18	300.8270948	300	1	2/28/74	1	3/1/74
19	301.3689885	301	0			3/2/74
20	301.9342964	301	1	3/2/74	1	3/3/74
21	302.5221482	302	0			3/4/74
22	303.1317065	303	0			3/5/74
23	303.7621637	303	1	3/5/74	1	3/6/74
24	304.4127386	304	0			3/7/74
25	305.0826731	305	0			3/8/74
26	305.7712299	305	1	3/8/74	1	3/9/74
27	306.4776906	306	0			3/10/74
28	307.2013552	307	0			3/11/74
29	307.9415423	307	1	3/11/74	1	3/12/74
30	308.69759	308	0			3/13/74
31	309.4688569	309	0			3/14/74
32	310.2547238	310	0			3/15/74
33	311.054594	311	0			3/16/74
34	311.8678945	311	1	3/16/74	1	3/17/74
35	312.6940754	312	0			3/18/74
36	313.5326102	313	0			3/19/74
37	314.3829944	314	0			3/20/74
38	315.2447453	315	0			3/21/74
39	316.1174009	316	0			3/22/74
40	317.0005194	317	0			3/23/74
41	317.8936793	317	1	3/23/74	1	3/24/74
42	318.7964795	318	0			3/25/74
43	319.7085397	319	0			3/26/74
44	320.6295007	320	0			3/27/74
45	321.5590252	321	0			3/28/74
46	322.4967973	322	0			3/29/74
47	323.4425221	323	0			3/30/74
48	324.3959245	324	0			3/31/74
49	325.3567474	325	0			4/1/74
50	326.3247494	326	0			4/2/74
51	327.2997023	327	0			4/3/74
52	328.2813881	328	0			4/4/74
53	329.2695968	329	0			4/5/74
54	330.2641239	330	0			4/6/74
55	331.2647692	331	0			4/7/74
56	332.2713354	332	0			4/8/74
57	333.2836283	333	0			4/9/74
58	334.3014559	334	0			4/10/74
59	335.3246298	335	0			4/11/74
60	336.3529654	336	0			4/12/74
61	337.3862821	337	0			4/13/74
62	338.4244044	338	0			4/14/74
63	339.4671616	339	0			4/15/74
64	340.5143878	340	0			4/16/74
65	341.5659223	341	0			4/17/74
66	342.6216086	342	0			4/18/74
67	343.6812951	343	0			4/19/74
68	344.7448347	344	0			4/20/74
69	345.8120853	345	0			4/21/74
70	346.8829105	346	0			4/22/74
71	347.9571803	347	0			4/23/74
72	349.0347722	349	0			4/24/74
73	350.115572	350	0			4/25/74
74	351.1994743	351	0			4/26/74
75	352.2863834	352	0			4/27/74
76	353.3762124	353	0			4/28/74
77	354.4688833	354	0			4/29/74
Sheet1

Cell Formulas
Range	Formula
N1:N77	N1	=A1:A77
J2:J77	J2	=TRUNC(I2)
K2:K77	K2	=COUNTIFS(J$2:J2,J2)-1
L2:L77	L2	=IFS(K2>=1,XLOOKUP(1,(J$2:J2=J2)*(K$2:K2=K2-1),$A$2:$A2),TRUE,"")
M2:M77	M2	=IFS(L2="","",TRUE,$A2-L2)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K2:K77,M2:M77	Expression	=$K2<>0	text	NO

 

[will20fitz]

The only thing I can think of is defining a fuzziness factor and compare the data against that factor:

Book001.xlsx
	A	B	C	D	E
1	1.23456	TRUE		Value	1.23456
2	1.23467	TRUE		Fuzziness	0.02
3	1.34567	FALSE
4	1.35678	FALSE
5	1.45678	FALSE
6	1.45789	FALSE
7	1.56789	FALSE
8	1.56891	FALSE
9	1.67891	FALSE
10	1.68901	FALSE
11	1.78901	FALSE
12	1.78012	FALSE
13	1.89012	FALSE
14	1.89123	FALSE
15	1.90123	FALSE
16	1.91234	FALSE
17	1.12345	FALSE
18	1.13456	FALSE
19	1.24567	TRUE
20	1.25678	FALSE
Sheet1

Cell Formulas
Range	Formula
B1:B20	B1	=ABS($E$1-A1)<=$E$2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B20	Cell Value	contains "true"	text	NO

thanks for this.... you got me close enough to then calc fairly quickly by hand! Cheers, Will