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
|