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.
Bookmarks