Awesome, works like a charm. Are you aware of any good resources on
array formulas? It seems like they are frequently the solution to my
problems but I don't quite understand the logic. For instance, I never
would have thought of putting an IF statement in this formula.

- John