One way is to strip the values of all the 12th cells
into say, another sheet ..

Assuming the data is in Sheet1, col BC

In Sheet2
-------------
Put in A1: =INDIRECT("'Sheet1'!BC"&ROW(A1)*12-10)

Copy down

This'll extract contents of Sheet1's
BC2,BC14,BC26,BC38,BC50 ..
into col A

Then just put in B1: =MAX(A:A)
should do it
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"John Dwyer" wrote in message
...
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