Loop through strings stop when strings change and start looping in the next column...?

**Prexcel** · 12-17-2013, 04:07 PM

Hi, I am looking to find the syntax to make a loop that does this:

I have 3 columns.

The first column holds repeating strings, after an irregular number of rows the string changes e.g. aa, aa, aa,... bb, bb,bb,bb,bb,... cc,cc,cc

I would like to know how I can tell the for loop to loop through aa, than loop through column 2 and 3 (to find the items I am looking for) and then continue looping through column 1 with bb.

I added arrows in the excel file to indicate the route the loop should take.

Any suggestions would be much welcome.

**PCI** · 12-17-2013, 05:11 PM

Try

Please Login or Register  to view this content.

**Prexcel** · 12-17-2013, 05:54 PM

Hi PCI,

it seems to do exactly what I want.
And that is why it is awesome. But I have to play with it for a while and understand all its moving parts and adjust it a little bit.
But I understand enough of the code to know that you just helped me out massively.

Thank you very much!

**Prexcel** · 12-17-2013, 06:14 PM

Dear PCI,

I wrote this code to find a this string "+" in the 2nd Column and this string "TP" in the 3rd column.
It work, but since I am a beginner it is probably a sub optimal solution for what I am doing. If you have a suggestion for improving the code I would be most thankful.

However, you have helped out already and the problem itself is solved!

Please Login or Register  to view this content.

**berlan** · 12-17-2013, 06:26 PM

Will your data always be sorted according to column F?

**berlan** · 12-17-2013, 06:49 PM

Here's also an alternative:

Please Login or Register  to view this content.

**Prexcel** · 12-18-2013, 03:31 AM

Hi Berlan,
yes, it will always be sorted according to F!
Thanks for the code, that looks great. I will check it out after work. Thanks a lot!

Loop through strings stop when strings change and start looping in the next column...?

LinkBack

Thread Tools

Rate This Thread

Display

Loop through strings stop when strings change and start looping in the next column...?

Re: Loop through strings stop when strings change and start looping in the next column...?

Re: Loop through strings stop when strings change and start looping in the next column...?

Re: Loop through strings stop when strings change and start looping in the next column...?

Re: Loop through strings stop when strings change and start looping in the next column...?

Re: Loop through strings stop when strings change and start looping in the next column...?

Re: Loop through strings stop when strings change and start looping in the next column...?

Thread Information

Users Browsing this Thread

Similar Threads

Change Cell Strings in Column to Replace Specifically the Second Character

[SOLVED] loop to match if shorter strings appears in longer strings

See if column of shorter strings appears in column of longer strings

SQL Strings, Looping and Using Date Values

Looping though multiple strings

Bookmarks

Bookmarks

Posting Permissions