Return duplicate max values in same cell

[Caren]

Hello,
I have a spreadsheet where column C a user must select a response of A,B,C.
At the bottom of the response list I have 3 cells with a formulae in each,
=COUNTIF(C5:C65,"A")
=COUNTIF(C5:C65,"B")
=COUNTIF(C5:C65,"C")
then below that a summary cell:
=MAX(C81:C83), which returns the counted number of times an option is
selected.
I then have a results cell with this formulae:
=IF(($C$84=$C$81),"A",IF(($C$84=$C$82),"B",IF(($C$84=$C$83),"C",""))). This
returns the 'users overall response'.

My question is - there may be times two responses have the same number of
selections - is there a way of return both results in one cell ie, A&B

Thank you in advance guys.
Caren.

 

[muddan madhu]

try this

=IF(C84=C81,"A","")&IF(C84=C82,"B","")&IF(C84=C83,"C","")

 

[Caren]

Thank you worked just fine.
Caren.

try this

=IF(C84=C81,"A","")&IF(C84=C82,"B","")&IF(C84=C83,"C","")