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
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)