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

°ª¤â¤j¤j½Ð±Ð¦p¦ó¥ÎVB±N¤@°ïdataÂনªí®æ,ÁÂÁÂ

°ª¤â¤j¤j½Ð±Ð¦p¦ó¥ÎVB±N¤@°ïdataÂনªí®æ,ÁÂÁÂ

°ª¤â¤j¤j½Ð±Ð¦p¦ó¥ÎVB±N¤@°ïdataÂনªí®æ?ÁÂÁÂ

pic

Â^¨ú3.JPG
2018-9-4 22:27
table.zip (16.78 KB)

TOP

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
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD