Iridium,
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.
Iridium,
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.
Iridium,
No, the 25 integer are in a row not in a column.
max: 10 / min: 0
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!!!