I entered the formula using Control - Shift - Enter (in case some of our
members don't know how to enter arrays) and it works.

However, any time I update a manager, it takes several minutes for the array
to recalculate the 3000+ lines. Can you think of a faster method?