Sweedler
Board Regular
- Joined
- Nov 13, 2020
- Messages
- 114
- Office Version
- 2016
- Platform
- Windows
- MacOS
Hello
I have a rather large spreadsheet, ca 150000 rows. In one column I have values in about 15000 cells, but they are not spread out randomly. I need a method of counting the amount of rows, in that column, that are between two cells with a value. I am not sure that this makes sense:
I hope this helps basically explain it
I have a rather large spreadsheet, ca 150000 rows. In one column I have values in about 15000 cells, but they are not spread out randomly. I need a method of counting the amount of rows, in that column, that are between two cells with a value. I am not sure that this makes sense:
This is the result I want - or some version of it | and then this step would be next | ||||||||
---|---|---|---|---|---|---|---|---|---|
30 | 30 | ||||||||
1 | 30-1 | ||||||||
2 | 30-2 | ||||||||
26 | 26 | ||||||||
1 | 26-1 | ||||||||
4 | 4 | ||||||||
1 | 4-1 | ||||||||
2 | 4-2 | ||||||||
3 | 4-3 | ||||||||
60012 | 60012 |
I hope this helps basically explain it