View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default row-indirect functions

This is an array formula, which means that you should type the
following:

= MIN(Data)+(ROW(INDIRECT("1:10"))*(MAX(Data)-MIN(Data)+1)/10)-1

but instead of pressing ENTER as normal, you should do CTRL-SHIFT-ENTER
at the same time. If you do it properly then Excel will wrap the curly
braces { } around the formula (do not type these yourself). If you need
to edit the formula, you should do C-S-E again, but you can copy and
paste the formula normally.

Hope this helps.

Pete