# getting the highest value per cell from various sheets

Hi guys i need to solve the following i have 3 tables fro a1 to p39 and all 3 sheets have different values. how can i make that in sheet 4 i have the maximum values of each cell compared from all the 3 sheets?

thank you

edit retag close merge delete

Do you will have a maximal values for each table or one maximal value from all tables?

( 2018-06-21 16:09:59 +0100 )edit

Surely you do not want the maximum values of each cell. The maximum value of a single cell is, well, the value of that cell of course. Please specify which cells to read to get a single maximum value. An example may help. Also, tell what you have tried so far.

( 2018-06-21 20:48:01 +0100 )edit

the fueling tables are different in each table, and i need that the blank sheet reflects only the highest cell values on each...so that i dont have to check each cell across the 3 sheets and write them down manually

( 2018-06-21 22:39:30 +0100 )edit

13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 13.5 17.5 17.5 17.5 17.5 17.5 17.5 17.5 17.9 18.7 19.5 21.5 21.5 21.5 21.5 21.5 21.5 21.5 21.5 21.5 21.5 25.9 25.9 25.9 25.9 25.9 25.9 25.9 25.9 25.9 25.9 31.1 31.1 31.1 31.1 31.1 31.1 31.1 30.3 29.9 29.9 37.9 37.9 37.9 37.9 37.9 37.9 37.9 36.7 35.5 34.7 39.9 55.9 55.1 54.7 51.9 ...(more)

( 2018-06-21 23:35:44 +0100 )edit

19.1 18.7 13.9 14.3 14.3 14.7 14.7 15.1 13.9 14.3 13.9 14.3 14.3 14.7 14.7 15.1 14.3 15.1 15.1 15.9 16.3 16.7 16.7 17.1 14.3 15.5 16.3 16.7 17.1 17.5 17.5 17.9 15.1 16.7 17.9 18.7 19.1 19.5 19.9 20.3 18.7 24.3 25.9 26.3 26.3 26.3 26.3 26.3 26.7 36.7 39.9 39.1 37.5 35.1 33.1 31.9 30.3 55.9 55.1 54.7 51.9 45.9 41.9 38.3 76.7 76.7 76.7 76.3 74.7 60.7 51.5 47.1 80.3 80.3 80.3 ...(more)

( 2018-06-21 23:36:13 +0100 )edit

this would be a fragment of sheet 1 and 2, can you see that per cell values change? well, i need only the highest value to be shown i a fresh blank table(sheet 3 in this case)

( 2018-06-21 23:37:37 +0100 )edit

Sort by » oldest newest most voted

use function MAX for each range

=MAX($Sheet1.A1:P39) =MAX($Sheet2.A1:P39)

=MAX(\$Sheet3.A1:P39)

more

The different sheets have a high value in different cells across the 3 sheets, and the 4th sheet I have left blank so that if possible by formula to show there te high valuue of each cell, thank you I need the evaluation of each cell as this has to do with engine management graphs, that's why I need that sheet 4 has only all the max values available from the three sheets

more

This should not be an answer. Instead, edit the question. See guidelines for asking. Also, please write in complete sentences and use a spell checker.

( 2018-06-21 20:43:46 +0100 )edit

k, mobile phone autofill

( 2018-06-21 22:40:02 +0100 )edit