Show most / least used text in a range


=INDEX(B7:M7;VERGELIJKEN(MIN(AANTAL.ALS(B7:M7;B7:M7));AANTAL.ALS(B7:M7;B7:M7);0) )
=INDEX(B7:M7;VERGELIJKEN(MAX(AANTAL.ALS(B7:M7;B7:M7));AANTAL.ALS(B7:M7;B7:M7);0) )

CTRL+SHIFT+ENTER!