View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Mc in StL Brian Mc in StL is offline
external usenet poster
 
Posts: 1
Default Statistics problem

I need to determine mean, median, mode, min, max and rank for a set of data
that exceeds a count of 255. Excel keeps locking up on me I think because
these functions are limited to arrays of 255 numbers or less.

Is there a way I can calculate these statistics on sets of data numbering in
the thousands?