Perform Loop until column reaches two consecutive blanks

I have information that's not always together in column A (i.e. there may be one blank cell between chunks of information).

In column I, I wish to type in "none" in all of its blank cells UNTIL two consecutive blanks in column A are reached.

I've included an example below.

To be more direct, I wish to parse through column A and count all the rows until there are two consecutive blank cells. For all the rows that are counted, I wish to write "none" in column I.

COLUMN A | COLUMN I
data | none
data | none
data | data
data | data
data | data
<blank> | none
data | none
data | data
data | none
data | none
<blank> | STOP
<blank>
<blank>

I've included "|" to help identify the diff between column A and column I
I would definitely appreciate if anyone could help me with this!!

Are the two blank cells indicative of the end of data? That is, there is no more data in column A after the two blank cells.

Regards, TMS

Please Login or Register  to view this content.

No loop required ...

Please Login or Register  to view this content.

Regards, TMS

Perhaps.

Please Login or Register  to view this content.

Gee golly that's smart. I didn't think to ask if there was no data after the double blank.

You're welcome.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Which column(s) are you looking in for blanks?

The code I posted looks in column A and it does works for all blanks.

Also, what do you mean that you want the code to work for both blank and non-blank cells?

@Norie: the problem is perhaps not well explained. My understanding is that, wherever you see "none" in the column I data, that will, in fact, be blank and those are the blank cells that need the word "none" inserting. I think the single blank cell in column A is a bit of a red herring.

My code could be reduced to a single line, as yours is, but I prefer to break it down. I find it easier to understand the steps I'm going through and, subsequently, to debug it.

Please Login or Register  to view this content.

This is looking at blank cells in column I, not column A, although it is limited by the number of rows of data in column A. Again, the "two blank cells" is another red herring ... he is just using that as the indicator that there is no more data (as questioned in post #2 and answered in post #3)


Regards, TMS