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 MI    Dec 12, 2012
user 2[H]ard said:(!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.

Row  Column A
1       LB-100
2       DW-102
3       DW-30
4       BJ-500
5       DW-50

Thanks for any help.

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