• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

to check sequence numbers

mohan08

Member
Hi,

Can you help me with formula for the below table.

I have multiple user with 5 different sizes, I need to check if the sizes are higher for the next sizes in sequence if its higher it should give me result as “In Sequence” or “Not In sequence”.
ProductsSize 1Size 2Size 3Size 4Size 5Results
AAA
1​
2​
3​
4​
5​
In Sequence
BBB
15​
22​
45​
54​
60​
In Sequence
CCC
10​
15​
8​
23​
45​
Not in Sequence
DDD
10​
15​
20​
30​
25​
Not in Sequence
 
Last edited:

Marc L

Excel Ninja
Hi,​
the kid formula : =IF((C2<B2)+(D2<C2)+(E2<D2)+(F2<E2),"Not ","")&"In Sequence" …​
 

mohan08

Member
Hi All,

i got the desired results if the range contains data, however incase of empty cell its not giving me the results. Can you help on the below.

ProductsSize 1Size 2Size 3Size 4 Size 5Results
AAA
1​
3​
5​
Not in Sequence
BBB
15​
22​
45​
54​
60​
In Sequence
CCC
10​
8​
45​
Not in Sequence
DDD
10​
15​
20​
30​
25​
Not in Sequence
 

Peter Bartholomew

Well-Known Member
73488

In that case, you can no longer compare a value to that immediately to its left. An alternative strategy might be to test whether any number corresponding to a smaller size is larger than the current value. The IF clause avoids testing blank cells and, instead, automatically passes them.
= SIGN(AND( IF(data<>"", (MAXIFS(data, size, "<"&size) < data), TRUE) ))
 
Top