Hi Terry,

Am Fri, 06 Sep 2019 14:49:43 +0100 schrieb Terry Pinnell:

No results are placed in col L for any valid set of four successive cells, such as
0.2
0.2
0.2
0.5
which should enter 2 in L2

for me it works fine.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgeYC...Kr88A?e=hrQzpl

If it doesn't work for you, your numbers are text formatted.


Regards
Claus B.
--
Windows10
Office 2016