View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Old Keith Old Keith is offline
external usenet poster
 
Posts: 31
Default Frequency formula

Thanks a lot, Harlan Grove, that changed a nightmare into a sweet dream !!

"Harlan Grove" wrote:

"Old Keith" wrote...
I copied a sample Frequency formula from the Help in Excel 2007 and it
works Ok, but I am unable to Edit it because it tells me I can't alter
an array.


You have to change all cells containing the array formula, so pick one of
the cells, edit the formula in it, hold down [Ctrl] and [Shift] keys and
press the [Enter] key.