- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 277
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-12-23
|
¦^´_ 13# chiyochao
©w¸q¦WºÙ
v=MIN(Sheet1!$I$2,SUMPRODUCT(((x=Sheet1!$I$1)+(y=Sheet1!$I$1))*1))
w=LARGE(IF((x=Sheet1!$I$1)+(y=Sheet1!$I$1),ROW(x),""),v)
x=OFFSET(Sheet1!$C$1,,,COUNTA(Sheet1!$C:$C),)
y=OFFSET(Sheet1!$D$1,,,COUNTA(Sheet1!$C:$C),)
z=OFFSET(Sheet1!$G$1,,,COUNTA(Sheet1!$C:$C),)
Àx¦s®æ¤½¦¡
I3=SUMPRODUCT(((x=$I$1)+(y=$I$1))*(ROW(x)>=w),OFFSET(y,,3))
I4=SUMPRODUCT(((x=$I$1)+(y=$I$1))*(ROW(x)>=w)*(OFFSET(y,,4)="¬O"))
®É¶¡¦¨¥».rar (13.52 KB)
|
|