How to create a sequence based on another column values?
Dears,
I need your help.
My problem is: I need to create a sequence in column B that is changing when a change in column A happens.
What I need exactly: I need the sequence to start from 20 then added by 20 whenever the value in column A still the same --- 20, 40, 60, .... But if the value in column A is changed then the sequence should start from the beginning again (20,40,..).
Hope you help me as I am stuck in this issue.
Best Regards
|