16th June 2005, 07:41 PM
|
Member
|
|
Join Date: Jan 1970
Location: n.s.w
Posts: 25
|
|
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.
|