| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Function to operate on ink linked to cell | Excel Worksheet Functions | |||
| Function to return colour of formatted cell | Excel Worksheet Functions | |||
Threaded Mode
