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.
Posts by ilikeit
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
-
-
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!!!