Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello
I need to return (potentially) duplicate values in one cell. My spreadsheet requires users to select a response in column C of A,B or C (from a drop down list). I have 3 formulas (hidden) counting the number of times a selection is made and one which returns the maximum from those 3 formulae.ie: =COUNTIF(C5:C65,"A") (this is in cell C81) =COUNTIF(C5:C65,"B") " C82 =COUNTIF(C5:C65,"C") " C83 =MAX(C81:C83) In cell C71 is a results box with this formulae: =IF(($C$84=$C$81),"A",IF(($C$84=$C$82),"B",IF(($C$ 84=$C$83),"C",""))) This obviously returns a text value based on the maximum times a response was selected. My question is - there are 13 questions and 3 responses per question, I need to know which is the most selected response (which I have managed), However, there may be a 'tie' as two options may come out equally eg, A has 3 responses, B and C have 5 responses each. I need to show in the results box 'B&C' Thank you in advance Caren. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return duplicate max values in same cell | Excel Discussion (Misc queries) | |||
Count duplicate cell values per month | Excel Worksheet Functions | |||
Warning while entering duplicate values in a cell | Excel Discussion (Misc queries) | |||
Why do my cell values/words duplicate themselves over and over? | Excel Discussion (Misc queries) | |||
Preventing user entering duplicate values in a cell range | Excel Worksheet Functions |