View Single Post
  #1   Report Post  
John Dwyer
 
Posts: n/a
Default Using the MAX function with "constant increment" cell references

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