Re Nyangu, Pagiel (CAP, GCF)'s message of 7 Aug 00: <...> > Suppose I were dealing with hundreds of combinations, how would I > make Excel help me list these numbers instead of just calculating > the number of combinations? Does anyone know if Excel can do this > task? I don't think you've explained _why_ you want these combinations listed. Do you want to do some nonparametric tests? If so, there may be other ways of approaching the problem that may be more efficient than an exhaustive listing of all possible combinations. Nigel _______________________________________ Nigel Greenwood London UK http://www.elgin.free-online.co.uk _______________________________________ %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%