Wednesday, May 8, 2013

yogi_Extract From Cells of Sheet1 Unique Strings Starting With Specified Characters

                                          Google Spreadsheet   Post  #1179
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May 08, 2013
user Hardy2 (!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