Dear all,
I have number of month names in A1:A24 (Jan, Feb, Mar, Apr). I need to know which month has occurred most frequently than others. An amazing formula is available to solve the problem written by admin of excelxor. (username)
=INDEX(A1:A24;MODE(MATCH(A1:A24;A1:A24;0)))
I just want to understand how this formula works. I can't achieve the same result by writing the parts of the formula. What does Match(A1:A24;A1:A24;0) do here? If it returns 24 results here then why doesn't it work when used separately? (If I type the formula in any given cell it'll return 1). Mode is set to return frequency of a number that most frequently occurs in a range and it doesn't work with text values. How does it work here?
Bookmarks