mode for TEXT in ROWS

[juriemagic]

Good day,

I am looking for the most occuring text in a row. I have tried various formulas, like mode.mult and mode.sngl, i have even tried

Please Login or Register  to view this content.

, which I got from this forum, but this array only works for columns...

Please...please...help..thank you very much..

[XOR LX]

Hi,

I've no idea what you mean by that "only working for columns" (?) but try this:

=INDEX(PO5:PZ5,MODE(MATCH(PO5:PZ5&"",PO5:PZ5&"",0)))

Regards