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:
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:
https://docs.google.com/
-------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment