Various complicated functions
=SUMMERPRODUKT((REST(KOLONNE(A1:A100)-KOLONNE(A1);7)=0)+0;ERTALL(SØK("tekst";A1:A100))+0)