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
{=INDEX(A1:A12,MATCH(MAX(COUNTIF(A1:A12,A1:A12)),COUNTIF(A1:A12,A1:A12),0),1)}
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
{=INDEX(C1:N1,MATCH(MAX(COUNTIF(C1:N1,C1:N1)),COUNTIF(C1:N1,C1:N1),0),1)}
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
Bookmarks