ibmy
Board Regular
- Joined
- Mar 4, 2020
- Messages
- 108
- Office Version
- 2016
- Platform
- Windows
Increasly
Column A - Column B
50 -
10 - (start of duplicate value)
10 - (end of duplicate value)
20 - 1
30 - 2
40 - 3
20 - (no count because the value lower than value from previous cell)
10 -
30 - (start of duplicate value)
30 - (duplicate value)
30 - (end of duplicate value)
20 - (no count because the value lower than duplicate value previous cell)
Decreasly
Column A - Column B
50 -
60 - (start of duplicate value)
60 - (end of duplicate value)
40 - 1
30 - 2
10 - 3
20 - (no count because the value higher than value from previous cell)
10 -
30 - (start of duplicate value)
30 - (duplicate value)
30 - (end of duplicate value)
40 - (no count because the value higher than duplicate value previous cell)
p/s : I tried =IF(A2>A1,"1","0") and =IF(A2<A1,"1","0") but failed when there is increase/decrease value without taking into account duplicate value since my limit knowledge to the excel formula. I only know basic formula.
Column A - Column B
50 -
10 - (start of duplicate value)
10 - (end of duplicate value)
20 - 1
30 - 2
40 - 3
20 - (no count because the value lower than value from previous cell)
10 -
30 - (start of duplicate value)
30 - (duplicate value)
30 - (end of duplicate value)
20 - (no count because the value lower than duplicate value previous cell)
Decreasly
Column A - Column B
50 -
60 - (start of duplicate value)
60 - (end of duplicate value)
40 - 1
30 - 2
10 - 3
20 - (no count because the value higher than value from previous cell)
10 -
30 - (start of duplicate value)
30 - (duplicate value)
30 - (end of duplicate value)
40 - (no count because the value higher than duplicate value previous cell)
p/s : I tried =IF(A2>A1,"1","0") and =IF(A2<A1,"1","0") but failed when there is increase/decrease value without taking into account duplicate value since my limit knowledge to the excel formula. I only know basic formula.