A simple but emergent help!!!

[ilikeit]

I am using MS WORD spreadsheet (EXCEL). I have random 25 integers for
each row and there are 100 rows. Now I want to find the sum of the 20
largest integers (out of 25) for each row. What is the fastest/easiest
way? Thanks and bow!!!

 

[Peo Sjoblom]

Don't know which is fastest but one way is, probably using large like

=LARGE('Sheet1'!$A$2:$Y$101,row(1:1))

then copy down 25 rows and sum that. To get it in one fell swoop

=SUMPRODUCT(LARGE(Sheet1!$A$2:$Y$101,ROW(INDIRECT("1:20"))))

 

[ilikeit]

Can you tell me how to sort a row? say I have 2 rows of integers:

1 3 9 7 5
8 4 6 2 0

I like to sort them into:

1 3 5 7 9
0 2 4 6 8

Thanks.

 

[Peo Sjoblom]

When you do a sort you can click the options, there you can select
orientation and select left to right

Also I noticed that I told you to copy down the formula 25 rows obviously
that should have been 20 rows

 

[Lloyd H. London]

Click on a cell with a value in the first row.
Open the Data menu, select Options. You will be able to choose to sort
from left to right, row, rather than top to bottom.

 

[Lloyd H. London]

Sorry, that is Data, Sort, Options.
My apologies

Click on a cell with a value in the first row.
Open the Data menu, select Options. You will be able to choose to
sort from left to right, row, rather than top to bottom.

 

[ilikeit]

Peo,

Thank you very much for your help. I have another question here: how to
find how many '0' for each row? For instance, I have 1, 0, 3, 0, 5, 9,
10 for row 1, so I should find 2 '0's. Thanks.

 

[Dave Peterson]

Take a look at the =countif() function:
like:
=countif(A1:H1,0)
(adjust the range for your data.