13284712166@ 发表于 2016-8-5 23:23
第一数提取:=MAX(IFERROR(--MIDB(A1,SEARCHB("?",A1),{1,2,3,4,5,6,7,8,9,10}),0)),数组公式.
第三数提取:=MAX(IFERROR(--MIDB(MIDB(MIDB(A1,SEARCHB("?",A1)+LEN(MAX(IFERROR(--MIDB(A1,SEARCHB("?",A1),{1,2,3,4,5,6,7,8,9,10}),0))),60),SEARCHB("?",MIDB(A1,SEARCHB("?",A1)+LEN(MAX(IFERROR(--MIDB(A1,SEARCHB("?",A1),{1,2,3,4,5,6,7,8,9,10}),0))),50))+LEN(MAX(IFERROR(--MIDB(MIDB(A1,SEARCHB("?",A1)+LEN(MAX(IFERROR(--MIDB(A1,SEARCHB("?",A1),{1,2,3,4,5,6,7,8,9,10}),0))),50),SEARCHB("?",MIDB(A1,SEARCHB("?",A1)+LEN(MAX(IFERROR(--MIDB(A1,SEARCHB("?",A1),{1,2,3,4,5,6,7,8,9,10}),0))),50)),{1,2,3,4,5,6,7,8,9,10}),0))),60),SEARCHB("?",MIDB(MIDB(A1,SEARCHB("?",A1)+LEN(MAX(IFERROR(--MIDB(A1,SEARCHB("?",A1),{1,2,3,4,5,6,7,8,9,10}),0))),60),SEARCHB("?",MIDB(A1,SEARCHB("?",A1)+LEN(MAX(IFERROR(--MIDB(A1,SEARCHB("?",A1),{1,2,3,4,5,6,7,8,9,10}),0))),50))+LEN(MAX(IFERROR(--MIDB(MIDB(A1,SEARCHB("?",A1)+LEN(MAX(IFERROR(--MIDB(A1,SEARCHB("?",A1),{1,2,3,4,5,6,7,8,9,10}),0))),50),SEARCHB("?",MIDB(A1,SEARCHB("?",A1)+LEN(MAX(IFERROR(--MIDB(A1,SEARCHB("?",A1),{1,2,3,4,5,6,7,8,9,10}),0))),50)),{1,2,3,4,5,6,7,8,9,10}),0))),60)),{1,2,3,4,5,6,7,8,9,10}),0)),数组公式 |