View Single Post
  #5  
Old 16th June 2005, 07:41 PM
Dalray Dalray is offline
Member
 
Join Date: Jan 1970
Location: n.s.w
Posts: 25
Default Laish

Sorry didn`t get back to you the result for my problem. I wore out a mouse trying to get it to work the way you and I thought. So had a big think. It won`t work because it is trying to sort on both plains ( rows & Collumns). So instead used the function MIN. this gave me the smallest no. ( Fav. ) in a new row. A good start. Then found function =small(array,1) new collumn copy down . Had fav. Again new collumn, Function =small(array,2) 2nd smallest no. 2nd fav) and so on . All 4 fav. Very pleased. Thanks for the help.

Ray.
Reply With Quote