本帖最后由 baksy 于 2014-7-10 16:06 编辑
QQ_500954 发表于 2014-7-10 09:00
麻烦你复制一下得了
A3=IFERROR(INDIRECT("Sheet1!R1C"&SMALL(IF(OFFSET(Sheet1!C$1:H$1,MATCH($A$1,Sheet1!B$1:B$9,)-1,)>0,COLUMN(OFFSET(Sheet1!C$1:H$1,MATCH($A$1,Sheet1!B$1:B$9,)-1,))),ROW(A1)),),"")
B3=IFERROR(INDIRECT("Sheet1!R"&MATCH(A$1,Sheet1!B$1:B$9,)&"C"&SMALL(IF(OFFSET(Sheet1!C$1:H$1,MATCH($A$1,Sheet1!B$1:B$9,)-1,)>0,COLUMN(OFFSET(Sheet1!C$1:H$1,MATCH($A$1,Sheet1!B$1:B$9,)-1,))),ROW(A1)),),"")
C3=IFERROR(INDIRECT("Sheet1!R2C"&SMALL(IF(OFFSET(Sheet1!C$1:H$1,MATCH($A$1,Sheet1!B$1:B$9,)-1,)>0,COLUMN(OFFSET(Sheet1!C$1:H$1,MATCH($A$1,Sheet1!B$1:B$9,)-1,))),ROW(A1)),),"")
D3=IF(B3="","",B3*C3)
A3,B3,C3公式三键回车( 公式复制后,点一下公式编辑栏的任意位置,先按住 shift、ctrl 两个键,然后敲enter键。)