Ubuntu
openoffice.org package

consolidate

Asked by sasikumar

i have around 10 values in 10 rows in excel sheet. now i want only maximum two values among that 10 values. that both values have to be averaged in separate column. is this possible in excel.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
mycae (mycae) said : 		#1

Assuming your data is in columns A and B on rows 1:10

In cell A11,
=max(A1:A10)

then drag this across into column B,

 then elswhere use

 =AVERAGE(A11:B11)

Can you help with this problem?

Provide an answer of your own, or ask sasikumar for more information if necessary.

To post a message you must log in.