¹¢¿ï¸ê®Æ¤Î²Îp¤å¦r¥X²{¦¸¼Æ?
- ©«¤l
- 142
- ¥DÃD
- 80
- ºëµØ
- 0
- ¿n¤À
- 221
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2021-4-28
|
¹¢¿ï¸ê®Æ¤Î²Îp¤å¦r¥X²{¦¸¼Æ?
|
|
|
|
|
|
- ©«¤l
- 1391
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1401
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-12-16
|
E2:E5{=IFERROR(INDEX(A:A,SMALL(IF(A$3:A$99>0,ROW(A$3:A$99)),ROW(A1))),"")
F2:G5=IF($E2="","",OFFSET($B$1,MATCH($E2,$A:$A,)+COLUMN(A1)-2,))
H2:H5=IF($E2="","",OFFSET($C$1,MATCH($E2,$A:$A,)-1,))
F2:H5¤@¦¡¤½¦¡=IF($E2="","",OFFSET($B$1,MATCH($E2,$A:$A,)-2+TEXT(COLUMN(A1),"[<3]0;!1"),COLUMN(A1)=3)) |
-
-
5182.png
(15.21 KB)
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 142
- ¥DÃD
- 80
- ºëµØ
- 0
- ¿n¤À
- 221
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2021-4-28
|
¤£¦n·N«ä¡AÁÙ¦³¤u§@ªí¢°§Ñ¤F¸ß°Ý¡A°ÝÃD¦p¤u§@ªí¢°¡C
ÁÂÁ¡I |
|
|
|
|
|
|
- ©«¤l
- 406
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 453
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2015-2-7
- ³Ì«áµn¿ý
- 2021-7-31
|
¥»©«³Ì«á¥Ñ n7822123 ©ó 2018-11-9 23:40 ½s¿è
¦^´_ 3# q1a2z5
¤u§@ªí1ªº³¡¤À¡A¤À¨âÓ¤½¦¡
E3:=COUNTIFS($A$2:$A$17,">" & DATEVALUE($D$2 &"/"& E$2),$A$2:$A$17,"<" & DATEVALUE($D$2 &"/"& E$2+1))
©¹¥k½Æ»s¨ìL3Àx¦s®æ
M3:=COUNTIF($B$2:$B$17,M$1)
©¹¥k½Æ»s¨ìO3Àx¦s®æ
¦pªG¸ê®Æ¶q«Ü¤j¡A«Øij¨ìµ{¦¡°Ï¡A¥ÎVBA¼g
ªþ¥ó9.rar (8.5 KB)
|
|
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U
|
|
|
|
|
- ©«¤l
- 2839
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2895
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-12-22
|
¥»©«³Ì«á¥Ñ ã´£³¡ªL ©ó 2018-11-10 10:13 ½s¿è
¤u§@ªí1:
AÄæ¤é´Á¦³16µ§, ¥k¤èn¨ú¥Xªº¤é´Á¥u¦³8®æ, ¤°»òÅÞ¿è???
n²Îp[¹q¸Ü/LINE/½u¤W]¤Sºò¾F¤é´Á¤§«á, Y¤é´Á¦³©Ò¼W´î, Äæ¦ì¬O§_¤Sn½Õ¾ã??? |
|
|
|
|
|
|
- ©«¤l
- 2839
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2895
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-12-22
|
¤u§@ªí2:
[¬y¤ô¸¹]³£¬O[¼ÆȮ榡]???
¦Ó¥B¨Ì¤p¦Ó¤j[©¹¤U±Æ§Ç]???
¨CÓ¬y¤ô¸¹©T©w¦û¥Î7¦æ??? ¨º¬°¦ón¨ú¥Xªº[¦WºÙ]¥u¦³¨â®æ???
E2:
=IF(ROW(A1)>COUNT(A:A),"",SMALL(A:A,ROW(A1)))
F2:¥k©Ô
=IF($E2="","",INDEX($B:$B,MATCH($E2,$A:$A,)+COLUMN(A$1)-1)&"")
H2:
=IF(E2="","",VLOOKUP(E2,A:C,3,)) |
|
|
|
|
|
|
- ©«¤l
- 142
- ¥DÃD
- 80
- ºëµØ
- 0
- ¿n¤À
- 221
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-4-14
- ³Ì«áµn¿ý
- 2021-4-28
|
¦^´_ 6# ã´£³¡ªL
¨º¬Oºô¸ô¤W¨C¤é¶ñ¼gªº¸ê®Æ¨Ã·J¥Xªº³øªí(excel®æ¦¡¡^¡A©Ò¥H¬y¤ô¸¹(³£¬O¼Æ¦r)¥B³£©T¦û¥Î7¦æ¨Ã¦X¨ÖÀx¦s®æ¡A¦WºÙ¨ºÄæ©ÒÅã¥Üªº¸ê®Æ¤]³£¥u¦³¤G®æ¡A
¥Ñ©ó¤u§@©Ò»Ý¡A¸Óºô¯¸¤Wªº¸ê®ÆµLªk²Îp§Ú·Qnªºµ²ªG¡A©Ò¥H¤W¸Óºô¯¸¸ß°Ý¡C
ÁÂÁ¡I |
|
|
|
|
|
|