d1,d2的公式分别为=TEXT(OFFSET(A1,MATCH("b",C:C,0)-1,0),"(0)")=TEXT(OFFSET(B1,MATCH("b",C:C,0)-1,0),"(0)")*****************=TEXT(OFFSET(INDIRECT(ADDRESS(1,ROW())),MATCH("b",C:C,0)-1,0),"(0)")你第一小问,我办不到,不好意思.
