°ª¤â¤j¤j½Ð±Ð¦p¦ó¥ÎVB±N¤@°ïdataÂনªí®æ,ÁÂÁÂ
- ©«¤l
- 23
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 30
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 64bit
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-8-13
- ³Ì«áµn¿ý
- 2019-1-13
|
°ª¤â¤j¤j½Ð±Ð¦p¦ó¥ÎVB±N¤@°ïdataÂনªí®æ,ÁÂÁÂ
°ª¤â¤j¤j½Ð±Ð¦p¦ó¥ÎVB±N¤@°ïdataÂনªí®æ?ÁÂÁÂ
table.zip (16.78 KB)
|
|
|
|
|
|
|
- ©«¤l
- 1
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN 7
- ³nÅ骩¥»
- 1
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-1-5
- ³Ì«áµn¿ý
- 2018-10-24
|
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-13
|
C6=B6&""
C10:C34=IF(A10="¼Ó",IFERROR(LOOKUP(1,0/(B$4:B4=B8)/(B$5:B5=B9),C$6:C6),"")&B10&CHAR(10),"")
J4:N4=LOOKUP(1,0/($B4:$B32=J2)/($B5:$B33=J3),$C6:$C34) |
-
-
5152.png
(14.48 KB)
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|