There are a few formulas in Google Spreadsheets that do not work simply with the arrayformula. However, with some careful manipulation it seems that it can be solved.
See the question asked by srdrum when trying to consolidate two forms.
Ahab came up with the formula and I did my best to alter and explain it to srdrum. Post any questions!
Thanks Ahab for your example!
Cheers!
No comments:
Post a Comment