Index/Match Finding Max

Good morning to all,
Using Excel 2010

I have a range of A1:A12 that has text (wind directions) and in A13 I have a formula to find what wind direction shows up the most in that range. Here is that formula

Please Login or Register  to view this content.

it gives the value of SSW (which appears 5 times in the range).

When I transpose the data across C1:N1 and have the formula in O1

Please Login or Register  to view this content.

it returns #REF!.
I need help rewriting the formula in O1 so that it returns SSW.

Attached is sample of worksheet. Thanks for any help you provide.
Mike

You need to switch the row/column arguments in the Index function when you are working with a row instead of a column...

i.e.

=INDEX(C1:N1,1,MATCH(MAX(COUNTIF(C1:N1,C1:N1)),COUNTIF(C1:N1,C1:N1),0))