index match ignore blank cells

[FXA]

I've been searching on how to ignore blank cells in this formula that "Finds the Most Frequently Occurring Text". When every cell is filled in, it works. In the attached screenshot where the #N/A is the intent is for it to be showing "OG" since that is the only text entered in this column.

=INDEX(Q10:Q1809,MODE(MATCH(Q10:Q1809,Q10:Q1809,0)))

Thank you in advance.

 

[Phuoc]

Try this

=INDEX(Q10:Q1809,MATCH(MAX(COUNTIF(Q10:Q1809,Q10:Q1809)),COUNTIF(Q10:Q1809,Q10:Q1809),0))

 

[FXA]

Prefect, thank you very much!

 

[Phuoc]

You're welcome!

 

[FXA]

I have another question here if you wouldn't mind taking a look at it?

$ amount does not calculate with a space

My issue is when I copy and paste from my source, that source has no comma in the dollar amount when the dollar amount hits the thousands and above. Is there a way around this? Formula: =C5+AK8+AK9+AK10 C5 = Starting Balance AK8 =SUM(N10:N1809) AK9 =SUM(L10:L1809) AK10 =SUM(M10:M1809)...

www.mrexcel.com