View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Michael is offline
external usenet poster
 
Posts: 18
Default Calculate every 5th Column.

On Fri, 15 Dec 2006 01:33:58 -0000, "Roger Govier"
wrote:

Hi Michael

Try the array entered formula
{=MAX(IF(MOD(COLUMN(A1:CL1),5)=0,A1:CL1))}

Use Control+Shift+Enter (CSE) to commit or edit the formula rather than
just Enter.
When you use CSE, Excel will insert the curly braces { } for you - do
not type them yourself.

Thanks Roger.