I have a very large table representing operations at different times, scattered with numbers but populated mostly with blanks.
It looks something like this,
I want to do some statistical analysis on the time between operations so I am hoping to produce a second table below the first that lists the number of blanks in each gap, sequentially for each column.
Something like this,
I know what the maximum number of gaps is, but the number of gaps in each column varies.
Can anyone think of a way to achieve this?
Bookmarks