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
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