=IF(AND( ISERR(FIND($D$2,A2)), ISERR(FIND($D$3,A2)), ISERR(FIND($D$4,A2)), ISERR(FIND($D$5,A2)), ISERR(FIND($D$6,A2)), ISERR(FIND($D$7,A2)), ISERR(FIND($D$8,A2)), ISERR(FIND($D$9,A2)), ISERR(FIND($D$10,A2)), ISERR(FIND($D$11,A2)), ISERR(FIND($D$12,A2)), ISERR(FIND($D$13,A2)), ISERR(FIND($D$14,A2)), ISERR(FIND($D$15,A2)), ISERR(FIND($D$16,A2)), ISERR(FIND($D$17,A2)), ISERR(FIND($D$18,A2)), ISERR(FIND($D$19,A2)), ISERR(FIND($D$20,A2)), ISERR(FIND($D$21,A2)), ISERR(FIND($D$22,A2)), ISERR(FIND($D$23,A2)), ISERR(FIND($D$24,A2)), ISERR(FIND($D$25,A2)), ISERR(FIND($D$26,A2)), ISERR(FIND($D$27,A2)), ISERR(FIND($D$28,A2)), ISERR(FIND($D$29,A2)), ISERR(FIND($D$30,A2)), ISERR(FIND($D$31,A2)), ISERR(FIND($D$32,A2)), ISERR(FIND($D$33,A2)), ISERR(FIND($D$34,A2)), ISERR(FIND($D$35,A2)), ISERR(FIND($D$36,A2)), ISERR(FIND($D$37,A2)), ISERR(FIND($D$38,A2)), ISERR(FIND($D$39,A2)), ISERR(FIND($D$40,A2)), ISERR(FIND($D$41,A2)), ISERR(FIND($D$42,A2)), ISERR(FIND($D$43,A2)), ISERR(FIND($D$44,A2)), ISERR(FIND($D$45,A2)), ISERR(FIND($D$46,A2)), ISERR(FIND($D$47,A2)), ISERR(FIND($D$48,A2)) ),"","有")
▽2
●
a-kuma3 ●125ポイント ベストアンサー |
B2 のセルに、以下のように式を入力。
=IF(SUMPRODUCT(COUNTIF(A2,"*"&$D$2:$D$48&"*")),"有","")
んで、下にコピーです。