ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó¨Ì¤£¦Pªº¦r¥y³£¯à¦¬¶°¸ê®Æ

¦p¦ó¨Ì¤£¦Pªº¦r¥y³£¯à¦¬¶°¸ê®Æ

¥»©«³Ì«á¥Ñ ¤d·u´M ©ó 2020-2-14 20:23 ½s¿è

¦p¦ó¯à¦h­Ó±ø¥ó³£¯à¦¬¶°¸ê®Æ-1.rar (28.6 KB) ²Ä2­Ó¤u§@ªí¤¤¦³3±i¥X³f³æ,²Ä1±i¬Oµu¯Ê,²Ä2±i¬O¥X¯²,²Ä3±i¬O¤@¯ë¾P°â,·Q­n¦¬¶°µu¯Ê©M¥X¯²ªº¸ê®Æ¤À§O¼g¤J²Ä1±i¤u§@ªí,§Ú¥u¯à¦U¦Û¼gµ{¦¡½X(´X¥G¬Û¦P,¥u¬O§PÂ_µü¤£¤@¼Ë),¦U°õ¦æ1¦¸,·Q½Ð¤j¤jÀ°¦£¼g¥X¤@³Ò¥Ã¶hªº¦h¦r¥y³£¯à¦¬¶°¸ê®Æ(¦]¬°¥H«á¤£¥u¬Oµu¤Ö,¥X¯²¦Ó¤w...) µù:¤£¤p¤ß¶Ç¤F3­ÓÀÉ®×,¤£ª¾¹D¦p¦ó§R¥h,³Ì¤W¤èªºÀɮפ~¬O¥¿½Tªº.

¦p¦ó¯à¦h­Ó±ø¥ó¯à¦¬¶°¸ê®Æ.rar (82.34 KB)

¦p¦ó¯à¦h­Ó±ø¥ó³£¯à¦¬¶°¸ê®Æ.rar (82.35 KB)

A2=TEXT(OFFSET('14'!C$4,ROW(A1)*6-6,),"M/D;;")
B2=OFFSET('14'!A$6,ROW(A1)*6-6,)&""
C2=IF(A2="","",IF(1-ISERR(FIND("RENT",OFFSET('14'!F$5,ROW(A1)*6-6,))),"¥X¯²","µu¤Ö"))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522 ÁÂÁ¤j¤jªº½ç±Ð,§Ú¸Õ¸Õ¬Ý.

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD