@
Classified You can use python to d any kind of data manipulation, it requires some programming skills, but for people who don't want to write code, there are some utilities like excel also has macros to find out what you want.
=IF(B4=2,"Prime",IF(AND(MOD(B4,ROW(OFFSET($A$2,,,ROUNDUP(SQRT(B4),0)-1)))<>0),"Prime","Not Prime"))