# Trying To Find The Maximum Value

#### Drip_Drip

##### Board Regular
I'm using the following Array to pick up the maximum value of a range of cells. Currently it only looks at the cells S4:W60

=MAX(IF(Data!\$B\$4:\$B\$60=Analysis!\$A12,Data!\$S\$4:\$W\$60,""))

I need to adapat it so that it picks up the maximum value between G4:K60, M4:Q60, S4:W60, Y4:AC60 and AE4:AI60.

Despite many attempts I'm unable to accomplish the task.

Any assistance would be appreciated.

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### barry houdini

##### MrExcel MVP
Do you have anything in a header row which would distinguish columns to ignore, i.e. in the header for columns L, R, X etc.?

That would probably make for a simpler formula, otherwise try

=MAX(IF(data!\$B\$4:\$B\$60=analysis!\$A12,IF(MOD(COLUMN(data!\$G\$4:\$AI\$60)-COLUMN(data!\$G\$4)+1,6)<>0,data!\$G\$4:\$AI\$60)))

confirmed with CTRL+SHIFT+ENTER

Replies
2
Views
571
Replies
10
Views
824
Replies
3
Views
476
Replies
4
Views
657
Replies
4
Views
686

1,191,609
Messages
5,987,648
Members
440,104
Latest member
thigarette

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back