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”.
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”.
Products | Size 1 | Size 2 | Size 3 | Size 4 | Size 5 | Results |
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: