Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MODE isn't working properly.
I am trying to find the mode of my array, but I want it to return nothing if
there is no number which occurs most often. Instead, they give me the first number which appeared. For example: MODE(4, 3, 4, 3) will return 4, and MODE(3, 4, 4, 3) will return 3. Is there some way I can fix or bypass this? |
#2
|
|||
|
|||
Hi!
Try this: Entered as an array using the key combo of CTRL,SHIFT,ENTER: =IF(LARGE(FREQUENCY(A1:A4,A1:A4),1)=LARGE(FREQUENC Y(A1:A4,A1:A4),2),"",MODE(A1:A4)) Biff "M Keeler" <M wrote in message ... I am trying to find the mode of my array, but I want it to return nothing if there is no number which occurs most often. Instead, they give me the first number which appeared. For example: MODE(4, 3, 4, 3) will return 4, and MODE(3, 4, 4, 3) will return 3. Is there some way I can fix or bypass this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CNTRL + END is not working properly | Excel Worksheet Functions | |||
Tab button not working properly | Setting up and Configuration of Excel | |||
Auto Filter not working properly | Excel Discussion (Misc queries) | |||
Macro "1 tall/1 wide" not working properly | Excel Worksheet Functions | |||
Replace function not working properly in Excel 2000 SP3 | Excel Worksheet Functions |