Reputation
Next privilege 200 Rep.
See reduced ads
Badges
3
Newest
 Editor
Impact
~7k people reached

Feb
10
revised how do I add isblank(ref) criteria to arrayformula?
changed formula to match OP's request