Google Spreadsheet Post #1753
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep-07-2014
post by Christopher Neu:
(https://productforums.google.com/forum/#!topicsearchin/docs/Meeting$20Tracker/docs/RZ58ASj7mYU)
Split a cell by multiple criteria
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep-07-2014
post by Christopher Neu:
(https://productforums.google.com/forum/#!topicsearchin/docs/Meeting$20Tracker/docs/RZ58ASj7mYU)
Split a cell by multiple criteria
I am trying to make a meeting tracker using a Google form for someone. The fields will include who was in attendance and meeting notes. The meetings will have a varying number of attendees. To simply the input I am telling the person to input the attendees by "FirstName LastName (Company Name), FirstName2 LastName2 (Company Name 2)" in succession in one field. I know how to perform a split by one delimiter (in this case the comma) but m wondering how to be able to separate the values into three columns so that each row has:
A B C D E
1 Meeting# MeetNotes FirstName LastName CompanyName
2 FirstName2 LastName2 CompanyName2
The meeting# field will be done from a dropdown of the meetings and the MeetNotes will be populated from that selection via index(match()). I have no doubt I can sort out matching up the attendees correctly as well but I just cant get the attendees to properly split as needed. Any help would be fantastic.
Thank you in advance,
Chris
Here is a link to the test sheet I am working with:
https://docs.google.com/
-----------------------------------------------------------------------------------------------------
No comments:
Post a Comment