Mode function for rows of text

[bat18]

Hi

I have a spreadsheet with columns of data running from column C to column Z.

In column B i am trying to work out which word appears the most.

For exaple in cell B2 i am looking for a formula to work out which word appears the most from cells C2:Z2.

Any help would be rerally appreciated.

Cheers

John

 

[Special-K99]

XL-CENTRAL.COM : Excel : Return the Most Frequently Occurring Value