Hello, and thank you in advance for any help you can offer. I have a spreadsheet that has 36 columns and 6000+ rows. Each column has a mix of blanks and content, which is an X. See example of the pattern below, column A. I want to run the COUNTBLANK function through the entire column A so that it assigns a value in column B, next to the content it relates to. Line B4, B9, and B11 would have results, in the example below. I want to be able to apply a formula the entire worksheet, all 36 content columns, and over 6000 rows, so that I can obtain the results quickly by filling down, across, etc. I suspect a loop might be in order, but I have no clue. Currently, I have to run the COUNTBLANK between one X and another, repeating that tediously over and over again. I would be forever grateful for help with this. -- Mike

---A----------------------------B
1 X
2 blank
3 blank
4 X--------------------Result is the number of blanks between this X and the X above it (which would be 2)
5 Blank
6 Blank
7 Blank
8 Blank
9 X--------------------Result is the number of blanks between this X and the X above it (which would be 4)
10 Blank
11 X-------------------Result is the number of blanks between this X and the X above it (which would be 1)
12 Blank