Check if range of cells are in ascending order based on repeating data in another cell

Hi 6StringJazzer - The code would have to say that for B--P--3, 3 is not correct. The desired value must be between 1 and 2.
Or if the user do not want to change 3 for B--P, the user has to update B--Q--2 to B--Q--4 (or any number higher than 3).

Sorry, I don't understand that explanation. 3 can be followed by any number higher than 3. Why can't 1 be followed by 3?

Given your data, then shouldn't BQ2 also be out of sequence? The only way that BQ2 can be in sequence is if the sequence is predetermined.

Examples are always important, but you have given a single example and are looking for us to extrapolate a complete set of rules from that. We need to understand all of your rules for determining if a set is out of sequence.

Hi 6StringJazzer - I changed my dataset to avoid confusion.

You've changed the data but the ambiguity is still there. You need to give a rule for this.

Please Login or Register  to view this content.

Hi @6StringJazzer - Col A and Col B does not need to be in sequence alphabetically (the nomenclature for A and B is free use). Only Col C need to be ascending. Each set in Col C (6 consecutive cells per set) has to be in ascending order, until Col A value changes.

The Excel solution to this is going to be trivial, but you can't get an Excel solution until the problem is defined, and IMHO that's not done yet. I think you have some intuitive notion of what you want but to express it formulas, you have to have a rigorous definition.

110.4 is greater than 100.12 so why is it out of sequence?
105.1 is NOT greater than 110.4, so why is it IN sequence?

Based on all your descriptions, 105.1 should be the only value that is considered out of sequence. You have not given a rule that explains why instead 110.4 is considered out of sequence. This was true of your original data, and also true of the data after you edited it. I have asked this three different times and the answer is just that the values have to be ascending. Well, they are all ascending until you hit 105.1.

A solution to a similar post can be found in http://www.excelforum.com/showthread...=1#post4451891

I have just returned from vacation so have not been following this. It looks to me like that other thread is not just a similar post but the same. I am glad you got a solution but I am closing this as a duplicate.

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.