View Single Post
  #1   Report Post  
obarahmeh obarahmeh is offline
Junior Member
 
Posts: 1
Default 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