In a statistical summary, I have a column that shows the mode (i.e., the
answer with the highest proportion of entries) for a the entires of a series
of likert scale ratings on a survey. I developed a nested "IF" function that
uses a series of "MAX" conditions. This does the job for the most part, but
there are instances where there is a tie for the mode, and rather than excel
showing both numbers, it shows the first in the series of the nested IF.

Here's the function I currently have enetered:
=IF(B7=MAX(B7,D7,F7,H7,J7,L7),"5",IF(D7=MAX(B7,D7, F7,H7,J7,L7),"4",IF(F7=MAX(B7,D7,F7,H7,J7,L7),"3", IF(H7=MAX(B7,D7,F7,H7,J7,L7),"2",IF(J7=MAX(B7,D7,F 7,H7,J7,L7),"1",IF(L7=MAX(B7,D7,F7,H7,J7,L7),"0"," N/A"))))))

What excel enters if 5 and 4 (i.e., B7 and D7) are a tie:
5

What I want excel to enter if 5 and 4 (i.e., B7 and D7) are a tie:
5, 4

Is there a way to revise my formula to make this happen?

--
-Zakhary