Hi,

I am looking for help regarding the following calculations in MS Excel. I have a sample data arranged like this in a column

variable name

2
3
14
4
blank
blank
blank
4
1
2
2
2
blank
blank
1
2
31
4
blank
1
blank
blank



I am interested in summarised two variables:

1) how can i get excel to count the number of columns in a data range that is present in a column continuously(numerical values) and print it in a separate column, for example, the output for sample data above would be
4
5
4
1

2) similarly how can i count the number of chunks of "blanks" and print it a separate column: for example the output from the above data sample would be:

3
2
1
2



Thanks for your help.