View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan[_14_] Ryan[_14_] is offline
external usenet poster
 
Posts: 2
Default excel help with min() fn reference

I have a column of 14595 observations.

I need to divide the 14595 observations into 695 groups (each with 21
obs), and to create a column of 695 observation of the minimum value
from each of the 695 groups.

Using min( ) (I assume), how can I reference the associated column so
I do not have to manually type the associated rows for each group?

Thanks.