| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
determine which cell is the max count
Thanks JMB,
I can solve the problem now. "JMB" wrote: also array entered with Ctrl+Shift+Enter. "JMB" wrote: overlooked the second part of your question - finding the one with the fewest entries. it's a bit longer, but I think this will work =INDEX(A1:A10,MATCH(SMALL(IF(A1:A10<"",COUNTIF(A1 :A10,A1:A10&"")),1),IF(A1:A10<"",COUNTIF(A1:A10,A 1:A10&"")),0)) "JMB" wrote: one approach you could try. I assume you do not want empty/blank cells considered? =INDEX(A1:A10,MODE(IF(A1:A10<"",MATCH(A1:A10&"",A 1:A10&"",0)))) array entered using Ctrl+Shift+Enter. of course it will only find the first one in case of a tie. "Kim" wrote: Hello guys, pls. help. Column A dog cat cat dog dog I would like to know which animal in the column A is max. or is min. the max. is dog. the min. is cat. What is the formula to use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine Value of Cell? | Excel Worksheet Functions | |||
| How to determine color of a cell? | Excel Worksheet Functions | |||
| in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
| determine which cell a value is returned from | Excel Discussion (Misc queries) | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
Hybrid Mode
