detect the 6 prime numbers in the list

detect the 6 prime numbers in the list
https://www.excelforum.com/attachmen...1&d=1582827386

Put this formula in Q6:

=IF(COUNTIF($A6:$O6,Q$5),"x",0)

Copy it into R6:V6, then copy those 6 formulae down as far as you need them.

Hope this helps.

Pete