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.