# What function do I need to use for this?

#### Kanekutter05

##### New Member
Which function do I need to use for this?

-I need a function that find the highest value that is in a specific cell on multiple sheets and put the highest value onto the 1st sheet.

Thanks for the help in advance

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Consider the following:
=MAX(N(INDIRECT("'"&ShtList&"'!A8")))

"ShtList" is the name of the range that lists the sheet names
A8 is the cell on each sheet that has the value
N.B. This formula is array entered with Ctrl+Shift+Enter not just Enter

or with Threed THREED from Mr. Longre's add-in Morefunc

=MAX(N(THREED('1:12'!A8)))

Or if you wish to put a sheet named Start in front of the relevant sheets and a sheet named
End after the relevant sheets, use

=MAX(N(THREED(Start:End!A8)))

Which function do I need to use for this?

-I need a function that find the highest value that is in a specific cell on multiple sheets and put the highest value onto the 1st sheet.

Thanks for the help in advance
Try something like this...

Return the max value from cell A1 on sheets Sheet1, Sheet2 and Sheet3.

=MAX(Sheet1:Sheet3!A1)

Replies
9
Views
357
Replies
2
Views
190
Replies
2
Views
237
Replies
3
Views
313
Replies
9
Views
997

### Forum statistics

Threads
1,203,521
Messages
6,055,885
Members
444,830
Latest member
Excelsmallbusinessmom

### 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.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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