most frequently occurring text, breaking ties

[lmleone]

Hello, I am using the following formula to identify the most frequently occurring text in a column, however, I can't figure out how to adjust this equation to output a specific text string indicating there is a tie.

=INDEX(range, MODE(MATCH(range, range, 0 ))).

Example:

apple
pear
apple
pear

Using this formula ( =INDEX(A1:A4,MODE(MATCH(A1:A4,A1:A4,0))) ) I get the output of "apple", but there is no majority so I would like the output to display "N/A"

Thank you!

 

[JGordon11]

Book3
	A	B	C	D
1	a		a
2	b
3	a
4	b
5	b
6	a
7	a
8
Sheet1

Cell Formulas
Range	Formula
C1	C1	=LET(r, A1:A7, s,COUNTIF(r,r), mx, MAX(s), IF(SUM(--(s=mx))>mx,"#NA", INDEX(r,MATCH(mx,s,0))))