One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=MAX(IF(MOD(ROW(B1:B1000),12)=2,B1:B1000,""))




In article ,
"John Dwyer" wrote:

I'd like to return the maximum value for every 12th cell
in a very long column of values. i.e. MAX
(BC2,BC14,BC26,BC38,BC50....) Can I do this using the MAX
function without listing each individual cell reference in
the function argument? If not, is there another way to do
this?

Thanks much,
John