| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I still cant get the six most common numbers to come up
when using:
C3:H204 = named range = rng Enter this formula in A3: =MODE(rng) Enter this array formula** in A4 and copy down a total of 5 cells (or as needed): =IF(ROWS($1:2)<=COUNT(1/FREQUENCY(rng,rng)),MODE(IF(COUNTIF(A$3:A3,rng)=0, rng)),"") Enter this formula in B3 and copy down as needed: =COUNTIF(rng,A3) The formula, =IF(ROWS($1:2)<=COUNT(1/FREQUENCY(rng,rng)),MODE(IF(COUNTIF(A$3:A3,rng)=0, rng)),"") It does work for the next number, but for the third number the formula shows up in the cell even though I press (ctrl shft entr) not the numer. What am I doing wrong??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| common numbers in 2 columns | Excel Worksheet Functions | |||
| Adding numbers from several worksheets with a common bond | Excel Worksheet Functions | |||
| Common Numbers Formula | Excel Worksheet Functions | |||
| Numbers from seperate worksheet to common sheet | Excel Worksheet Functions | |||
| finding common numbers in large lists | Excel Worksheet Functions | |||
Threaded Mode
