Help for formula

[mdileep]

I have 4 excel sheets, cell A1 to cell A4 have some value on all 4 sheets. How I get max value of all four sheets by formula, without specify each sheet's name separately.
MSExcel version 2007

 

[awoohaw]

Any formula must reference the cell. And if on a different worksheet the worksheet must be identified.
But, if you're asking for say for consecutive worksheets in the workbook. Say you have six worksheets and want to get max of cells A2:A5 in the middle 4, you can try:

  =MAX(Sheet2:Sheet5!A2:A5)

 

[Muhammad_Usman]

Assuming you have Sheet1, Sheet2, Sheet3, and Sheet4, and you want to find the maximum value in cell A1 to A4 across all of them:

1. In the cell where you want to display the maximum value, enter the following formula:

=MAX(Sheet1:Sheet4!A1:A4)

 

[mdileep]

Assuming you have Sheet1, Sheet2, Sheet3, and Sheet4, and you want to find the maximum value in cell A1 to A4 across all of them:

1. In the cell where you want to display the maximum value, enter the following formula:

=MAX(Sheet1:Sheet4!A1:A4)

Fine Sir, Thanks.