Tuesday, December 29, 2015

yogi_From Data In Column F Pull The First Word And Then The Word Between Second and Third '-' Characcters

Google Spreadsheet   Post  #2000
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-29-2015
post by  Gregory Han:
https://productforums.google.com/forum/#!topic/docs/pyL3jHPpLtM;context-place=forum/docs
Concatenate and filter
Hi, I imported a csv into sheet 1 and wanted to efficiently sum up the values for specific names. I had first taken column A and column B and concatenated them into column r using: 

from there in column S i want to filter using select words from column r such as:

livingston united states fitdaily oz rejuvolyte
livingston united states fitdaily oprah rejuvolyte
livingston united states fitfaily oz rejuvanage

into:

livingston rejuvolyte
livingston rejuvanage


what formula can i use in column S
any help would be welcome, thanks!

to be more specific i have included the sheet:
-------------------------------------------------------------------------------------------------------------------------