With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, December 12, 2012
yogi_Extract Row Numbers Where Entries In Column A Begin With A Specified String
Google Spreadsheet Post #925
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Dec 12, 2012 user 2[H]ard said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/5Xw0ccPSM0E) Return row numbers on a separate spreadsheet from partial string match
Windows 7 on Chrom
So I need to be able to return the row number of multiple partial string matches. Example is below. I need to be able to return so A1=2, A2=3,A3=5 based off a partial string match of "DW". Is this possible? The reason I want to do this is so I can use the row number in an importrange function and return all the other values I need in each row off a Master sheet so I can give viewing permissions to the sub spreadsheets but update on the Master sheet.
in the following I have presented a solution to a bit more generalized problem -- I have extracted the row numbers in column C of the same sheet, for extracting the row numbers in another sheet, the formula in cell C1 can be moved to cell A1 of the other sheet