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

[µo°Ý] ¦p¦ó¥H³Ì«á¤@µ§¥X²{¦ì¸m,¬Û¹ïÅÜ´«Åã¥Ü¦WºÙ

[µo°Ý] ¦p¦ó¥H³Ì«á¤@µ§¥X²{¦ì¸m,¬Û¹ïÅÜ´«Åã¥Ü¦WºÙ

¦­¤È±ß¤î.rar (6.23 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2015-11-19 12:51 ½s¿è

¦^´_ 1# starry1314
Àx¦s®æB6¿é¤J°}¦C¤½¦¡ (¥HCtrl+Shift+Enter¿é¤J)
=INDEX($A$1:$A$4,MAX(IF(B1:B4="p",ROW(B1:B4),"")))&"¤î"
¦V¥k½Æ»s
½Ð°Ñ¦Ò¡I

TOP

=LOOKUP(1,0/(B2:B4<>""),$A2:$A4)&"¤î"

TOP

¦^´_ 3# hcm19522

¯u¬O¤Ó·PÁ¤F~§¹¥þ¨S¬Ý¹Lªº¥Îªk

TOP

¦^´_ 2# p212

·PÁÂ~·s¾Ç¤@©Û

TOP

¦^´_ 3# hcm19522
¤j¤j§A¦n,
½Ð°Ý³o­Ó¤½¦¡­n¦p¦ó¿é¤J?­n©ñ¦b¨º¸Ì?
¤S¤½¦¡¬O¦p¦ó¹B§@ªº?

TOP

¥»©«³Ì«á¥Ñ yen956 ©ó 2015-11-19 18:03 ½s¿è

¦^´_ 5# starry1314
Sorry, ¤w¸gª¾¹D¦p¦ó¿é¤J¤F, »P2Fªº¿é¤Jªk¤@¼Ë!
¦ý°}¦C¤½¦¡¬O¦p¦ó¹B§@ªºÁÙ¬O¤@ÀYÃú¤ô!!

TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD