Ask Your Question
0

getting the highest value per cell from various sheets

asked 2018-06-21 15:22:12 +0200

Dany1000 gravatar image

updated 2018-06-21 15:40:35 +0200

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 flag offensive close merge delete

Comments

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

kompilainenn gravatar imagekompilainenn ( 2018-06-21 16:09:59 +0200 )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.

Jim K gravatar imageJim K ( 2018-06-21 20:48:01 +0200 )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

Dany1000 gravatar imageDany1000 ( 2018-06-21 22:39:30 +0200 )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)

Dany1000 gravatar imageDany1000 ( 2018-06-21 23:35:44 +0200 )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)

Dany1000 gravatar imageDany1000 ( 2018-06-21 23:36:13 +0200 )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)

Dany1000 gravatar imageDany1000 ( 2018-06-21 23:37:37 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2018-06-21 16:14:30 +0200

kompilainenn gravatar image

use function MAX for each range

=MAX($Sheet1.A1:P39)

=MAX($Sheet2.A1:P39)

=MAX($Sheet3.A1:P39)

edit flag offensive delete link more
0

answered 2018-06-21 17:02:51 +0200

Dany1000 gravatar image

updated 2018-06-21 17:04:48 +0200

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

edit flag offensive delete link more

Comments

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.

Jim K gravatar imageJim K ( 2018-06-21 20:43:46 +0200 )edit

k, mobile phone autofill

Dany1000 gravatar imageDany1000 ( 2018-06-21 22:40:02 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-06-21 15:22:12 +0200

Seen: 52 times

Last updated: Jun 21 '18