Google Spreadsheet Post #1179
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 08, 2013
user Hardy2 (https://productforums.google.com/forum/?hl=en#!category-topic/docs/spreadsheets/Kt_H9z_rano)
Colate specific strings and list to a new sheet ?
I’m puzzling over this. I have “Sheet1” with cells say A1 to E33 with test results in the form of strings. These cell strings include “Pass”, “Fail”, etc but also a few with a reference like “artfxxxxx”, where xxxxx is a varying five digit number. I want to find in “Sheet1” the unique “artfxxxxx” strings only and list them in a column in say “Sheet2” ?
Here is an example of what I'm trying yo achieve...
Sounds like it should be easy, thanks.----------------------------------------------------------------------------------------------------------------------
let us have a look at the following
No comments:
Post a Comment