| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Formula based Cell Content Return Unique Consecutive Duplicate Values | Excel Worksheet Functions | |||
| Return Unique Consecutive Duplicate Values across Single Row | Excel Worksheet Functions | |||
| Return Unique Duplicate Numeric Values across Single Row | Excel Worksheet Functions | |||
| Find Duplicate Values and Return Another Value | Excel Worksheet Functions | |||
| Why do my cell values/words duplicate themselves over and over? | Excel Discussion (Misc queries) | |||
Hybrid Mode
