level 1
data1 = Import["C:\\Users\\vincen\\Desktop\\222.xlsx"]
data = Part[data1, 1]
a = Table[0, Length[data]];
b = Table[0, Length[data]];
start = "S3139";
end = "S1589";
For[i = 1, i <= Length[data], i++,
For[j = 1, j <= Length[Part[data, i]], j++,
If[start == Part[Part[data, i], j], ReplacePart[a, i -> 1]]]]
For[i = 1, i <= Length[data], i++,
For[j = 1, j <= Length[Part[data, i]], j++,
If[end == Part[Part[data, i], j], ReplacePart[b, i -> 1]]]]
For[i = 1, i <= Length[data], i++,
If[(a[i] = 1) && (b[i] = 1), Print[Part[Part[data, i], 1]]]]
2018年08月14日 03点08分

