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
use function MAX for each range
=MAX($Sheet1.A1:P39)
=MAX($Sheet2.A1:P39)
=MAX($Sheet3.A1:P39)
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
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.
Asked: 2018-06-21 15:22:12 +0100
Seen: 164 times
Last updated: Jun 21 '18
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Do you will have a maximal values for each table or one maximal value from all tables?
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.
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
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)
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)
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)