vendredi 2 février 2018

Performing count and max commands on multiple groups of rows in Excel

Let's say you have rows: 0.000
0.000
0.000
5.000
6.000
10.000
0.000
0.000
0.000
5.000
...
I need a set of commands that can count the number of zeros between each set of numbers and report it in the next column, count the number of non-zero cells in each group and report it, and find the max in each set of non-zero numbers i.e.:
Col A Col B (count) ColC (max)
0.000
0.000
0.000 3
5.000
6.000
10.000 3 10.000
0.000
0.000
0.000 3
8.000
20.000
50.000 3 50.000
0.000
...
For clarity I want to do this programmatically. So if I load up 1,000,000 rows with patterns like the above, column B and C automatically populate.
Thanks in advance for the excel fu!

Aucun commentaire:

Enregistrer un commentaire