Most common string in column with an exception

[Bytor47]

I am trying to find the most common string in a column but I need to ignore a certain value.

I found this formula in another thread and it works great for it's intended purpose but I need to modify it to ignore 0's.

=INDEX(A2:A10,MODE(MATCH(A2:A10,A2:A10,0)))


Example Data:

john
mary
john
0
0
mary
bill
john
0
0


The result should be john not 0. Is this possible?

Any help is greatly appreciate.

Thanks
Rob