Thread
:
Calculate every 5th Column.
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Michael
external usenet poster
Posts: 18
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
Reply With Quote
Michael
View Public Profile
Find all posts by Michael