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

PASTE(only value) + Skip blanks ¥\¯à¬O¥Î¤£¨ì?

PASTE(only value) + Skip blanks ¥\¯à¬O¥Î¤£¨ì?

¦bA1®æ   =IF(100+300=500,TRUE,FALSE)     =====> ±o¥Xµ²ªG FALSE
¦bA1®æ   =IF(100+300=500,C1,C2)                  =====> ±o¥Xµ²ªG C2           (¦pªGC2 ¬OªÅ¥Õ´N·|ÅÜ 0 )
¦bA1®æ   =IF(100+300=500,C1,"")                    =====> ±o¥Xµ²ªG ¤]¬O ªÅ¥Õ


¦pªG±N A1®æ ¥Î COPY ¦A PASTE(only value) ¥hC20®æÀ³¸Ó¬O  ªÅ¥Õ (§Y¬O¨S¦³¼Æ¾Ú­È)

°ÝÃD:     ´N¬O (¦pªG¦bC20ªº½d³ò¥ÎCTRL +¤W¤U¥ª¥k°»±´®É ) ´N·|µoı  ©Ò¿×ªºªÅ¥Õ ¬O¦³ ¼Æ¾Ú­È

½Ð°Ý¦³¨S¦³¨ä¥L¤èªk¥h­×§ï ?   (  ¯u¥¿¨S¦³¼Æ¾Ú­È  )

¥Î COPY ¦A PASTE(only value) + Skip blanks ¥\¯à¬Oµo´§¤£¨ì ( ¦]¬°©Ò¿× Skip blanks ªº blank ¬O¦³¼Æ¾Ú­È )

¦^´_ 2# sunnyso


blank.rar (3.03 KB)
½Ð¬ÝªþÀÉ

TOP

ÁÙ¬O¤£²M·¡°ÝÃD¡A¬O­þùØcopy¨ì­þùØ
ss

TOP

¦^´_ 4# sunnyso
1

2     3

4     5

6     7

§A¬Ý¹Ï¤ù ¥h²Ä4®æcopy µM«á¦A¥Î ( paste special ¬J format + skip blank ) ¥h²Ä1®æ
undo ¥H¤W   ¸Õ¤U¥Î ²Ä5®æcopy µM«á¦A¥Î ( paste special ¬J format + skip blank ) ¥h²Ä1®æ    §A´N¬Ý¨ì°ÝÃD!!!!

TOP

excel  "" ¤£µ¥©ó blank
ss

TOP

¦^´_ 5# jakcy1234


    sonny-e.gif
ss

TOP

¦^´_ 7# sunnyso

«YØ{ ¥i¥H¥Î¨ì add value ¥N´À
¦ý¬Oexcel ¬Jblank «Y¦³bugs §Ú¦n¦h¤½¦¡³£¥Î ""  ©Î hide 0;-0;  ¥h¥N´À
·PÁ±z ¸Ñ¨M³o­ÓÃøÃD

TOP

³o¤£¬Oexcelªºbug¦]¬°""¤£µ¥©óblank
""+blank ¤~¬Oblank
ss

TOP

EXCEL¤W BLANK ªº·N«ä¬O"¤°»ò³£¨S¦³",
¦³FORMULA´N¤£¬OBLANK¤F
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD