Mode calculation if there is blank cells

[Speranza82]

I am trying to calculate the most reoccurring text in cells that contain blank cells

Code I tried
=INDEX(A2:A20,MODE(IF(A2:A20<>"",MATCH(A2:A20,A2:A20,0))))

but I am struggling to find what condition to use to remove counting the blank cells.

Any suggestions

Thank

 

[steve the fish]

Hi. That shouldnt count blank cells. Are you using CTRL-SHIFT-ENTER?

 

[gaz_chops]

Why not just use =Mode(A2:A20)

 

[gaz_chops]

Ignore ^ that, realised after I posted!