Index, Mode & Match Problem?

I have a column of text values which the below formula is evaluating and is then returning the most frequent text value.

=INDEX(A:A,MODE(MATCH(A:A&"",A:A&"",0)))

It works fine when the specified array includes text values, my problem is i am adding to the text values daily and would prefer not to have to adjust the array of the formula each time!

When i specify a larger array (ie. A3:A1000) it returns "0".

Is there any way to combat this?


Thanks in advance

Try this "array formula"

=INDEX(A3:A1000,MODE(IF(A3:A1000<>"",MATCH(A3:A1000,A3:A1000,0))))

needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar

Works perfectly!!

Thanks very much!