google sheets mode text code example

Example: google sheets mode text

=index(D4:L4; match(max(countif(D4:L4; D4:L4)); countif(D4:L4; D4:L4); 0))