| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reverse Frequency
I copied this formula in E4 In E4 this array formula: =IF(ROW()-ROW($E$4)+2COUNTIF($B$2:$B$25,E$2),"-", INDEX($A$2:$A$25,MIN(IF(($B$2:$B$25=E$2)*(COUNTIF( $E$3:E3,$A$2:$A$25)=0),ROW($B$2:$B$25)-ROW($B$2)+1)))) Problem seems to be in this part of the formula IF(ROW()-ROW($E$4)+ - - - - - - - - - With Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Frequency | Excel Discussion (Misc queries) | |||
| FREQUENCY HELP PLEASE | Excel Worksheet Functions | |||
| Frequency | Excel Worksheet Functions | |||
| histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
| frequency | Excel Discussion (Misc queries) | |||
Threaded Mode
