return list value if true and increment row

**K.J.Dub** · 10-30-2012, 05:59 PM

Hi,

I am trying to create an automatic list of indexed names by referencing a list. Once a condition is met (see excel sheet), the name indexes to the next value in the list. Every time this condition is met, I need this index to occur. Excuse my poor description, it's my first post.

Cheers,

Kyle

**Pete_UK** · 10-30-2012, 06:04 PM

Well, I've looked at your attached file and I don't understand what you want to achieve, so maybe in your second post you could try to describe things a bit more clearly.

Pete

**K.J.Dub** · 10-30-2012, 06:10 PM

The index list is on the setup page, I want to index through the array from "" to A to B (continuous through the array). I want the index to happen once the condition is met in column D where the current value is higher than the previous. I need to rewrite the formula in colum B on the design page to achieve that. Note: The array can have various combinations of letters in no particular order following the first value ("").

**Pete_UK** · 10-30-2012, 07:09 PM

I think I know what you mean - put this formula in B4 of the Design sheet:

Formula:

Please Login or Register  to view this content.

then copy down.

Hope this helps.

Pete

**K.J.Dub** · 10-31-2012, 09:50 AM

Awesome work Pete!

**Pete_UK** · 10-31-2012, 11:22 AM

Glad to be of help. If you now consider that this problem has been solved, please mark the thread as Solved (the FAQ describes how).

Also, for future use, you can click on the "star" icon in the bottom left corner of any post that you have found to be helpful, in order to pass thanks on more directly to a contributor.

Pete