CODEWITHSUNDEEP
excelexcel-formulaworksheet-function
Ashraf Khaled
Ashraf Khaled

Reputation: 91

Check if column values are increasing

I got an Excel sheet like:

A     B       C
1     L11     6
1     L21    10
1     L31    20
2     L12     5
2     L22    15
2     L32    23

I want to make a formula to check if each consecutive 3 values in column C are increasing. How can I do it?

I've tried to group by, but was in vain.

Upvotes: 1

Views: 1303

Answers (2)

Praveen
Praveen

Reputation: 119

If you want to quantify the trend here I am using a simple formula to calculate the slope for the 3 numbers using the values in y axis.

Formula

=SLOPE(N2:N4,{1;2;3})

enter image description here

Upvotes: 0

ZygD
ZygD

Reputation: 24448

If the value 6 is in C1, then you could put the following formula in D3: =AND(C3>C2, C2>C1)

Copy it down. If it's TRUE, it means that each consecutive 3 values in column C are increasing.

enter image description here

Upvotes: 4

Related Questions