A simple but emergent help!!!

  • Thread starter Thread starter ilikeit
  • Start date Start date
I

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!!!
 
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"))))
 
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.
 
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
 
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.
 
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.
Click to expand...
 
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.
 
Take a look at the =countif() function:
like:
=countif(A1:H1,0)
(adjust the range for your data.
 
Back
Top