How to ignore blanks in Index match formula?

[doand1]

Hi All,


I'm using the following formula to look at a range of cells and return the most common text entry. The formula works fine as long as there is text; if there are more blank cells than entries, then it returns a 'blank' and my formula cell is empty. Please note, column C is also a formula, not text. Does anyone have a pointer on how to clean this up so that it ignores blank cells?

Right now, blank is the most common and its returning blanks. I want to ignore those.

Thanks!
=INDEX(C8:C42,MODE(MATCH(C8:C42,C8:C42,0)))

 

[martindwilson]

x-post @
How to ignore blanks in an Index/Match Array Formula