79725982

Date: 2025-08-05 10:39:15
Score: 0.5
Natty:
Report link

Another option is to do a somewhat reverse COUNTIF with wildcards.

=INDEX(SUM(COUNTIF(E16, "*"&My_List&"*")))

This will return the number of case-insensitive matches and will ignore blank cells and any cells with errors.

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: bricks96