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

[µo°Ý] ¥ô¦ó¾°È¶W¹L¤u§@¤»¤Ñ¥X²{¬õ¦â©³¦â

[µo°Ý] ¥ô¦ó¾°È¶W¹L¤u§@¤»¤Ñ¥X²{¬õ¦â©³¦â

·Q½Ð°Ý ¦U¦ì°ª¤â ,

"¨Ò"¤§¶¡ ¶¡¹j¶W¹L¤»¤Ñ¥X²{¬õÃC¦â

201710.rar (23.98 KB)

=(G4="¨Ò")*(MATCH("¨Ò",H4:AJ4,)>6)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

=1-ISERROR(FIND(REPT("¤é",6),SUBSTITUTE(SUBSTITUTE(PHONETIC(G4:AJ4),"1",""),"2","")))

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD