Saturday, March 24, 2012

yogi_Match Specified Attribute In An Array And Concatenate All Associated Email Addresses

Yogi Anand, D.Eng, P.E.                Google Spreadsheet          Post  #482

My following solution to the problem came about from a discussion with my dear friend and fellow Top Contributor on Google Docs Help forum TedJ -- a simple row by row formula sported a rather straightforward solution, but the idea was to come up with an arrayformula that will lend itself for auto propagation in use with Form input.
so here we go ... I realize it is a pretty convoluted solution ... and if I come up with a simpler and/or more streamlined solution, i will post an update ...