View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
smandula smandula is offline
external usenet poster
 
Posts: 116
Default 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