Sep 03 2021 03:58 AM
Sep 05 2021 03:19 PM
Perhaps simpler formulas would make it work. See the attached. I was able to replicate your results without such an elaborate formula. I'm not a VBA proponent, for the most part, having been convinced over many years that the right formula often (admittedly not always) is more efficient than the "brute force" method.