When you apply F8 and the local window, I think the array approach is much easier to follow than the Excelformulae-in-VBA approach.
Maybe it takes some time the first time, but when grasping the code sets in, the learning process is much faster ( own experience).