Ask Your Question

Revision history [back]

Solved this. Did not understand that I needed to end the formula with Ctrl, Shift, Enter to turn the formula into a Dynamic Array Formula. Yhen it works just fine.

Corrected sheet attached

C:\fakepath\sample 1.xlsx