1.ABCD 2.ACD 3.ABD 4、AC 5.BC 6.ABC 7.AD 8.CD 9. BD 10. ABD 11. CD 12. AC 13. AB 14. BD 15. AD 16.ABD 17.ACD 18.CD19.ACD 20.ABCD 21.BCD 22.ABCD 23.BCD 24.BD 25.BCD 26.BC 27.ABC 28.ABCD 29.AD 30.ABCD 31.BCD 32.ABD 33.AB 34.BCD 35.BCD 36.AD 37.ABCD 38.BD 39.AB 40.BD 41.CD 42.ABD 43.BC 44.ABC 45.BD 46.AC 47.ABC 48.AC 49.BCD 50.ABD 51.ACD 52.ABCD 53.ABCD 54.AD 55.ABC 56.AD 57.AD 58.ABC 59.BC 60.ABC 61.ABC 62.ABCD 63.ABCD 64.ABC 65.AC 66、ABD 67、AB 68、AC 69、AD 70、ABCD
本帖最后由 baksy 于 2014-10-1 10:38 编辑
请参考
A1公式,下拉;
=IF(ROW()>70,"",IF(ROW()=70,MID(PHONETIC($C$1:$C$5),FIND(70,PHONETIC($C$1:$C$5)),9),MID(PHONETIC($C$1:$C$5),FIND(ROW(A1),PHONETIC($C$1:$C$5)),FIND(ROW(A2),PHONETIC($C$1:$C$5))-FIND(ROW(A1),PHONETIC($C$1:$C$5)))))
|