Great personal satisfaction in wrangling built in formula to do this but also a Google Apps Script demo as well (the array/cell detection in the script solution is one I'll probably use again. Is there a better way of doing it?)
Shared publiclyView activity