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.
|