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

On Thu, 14 Dec 2006 17:35:00 -0800, Max wrote:

Try, array-entered (press CTRL+SHIFT+ENTER):
=MAX(IF(MOD(COLUMN(E1:IV100),5)=0,E1:IV100))

Thanks Max