Return duplicate max values in same cell
 

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.

Return duplicate max values in same cell
 

try this

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


On Feb 12, 4:06*pm, Caren wrote:
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.

Return duplicate max values in same cell
 

Thank you worked just fine.
Caren.

"muddan madhu" wrote:

try this

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


On Feb 12, 4:06 pm, Caren wrote:
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.