I want to update a column dynamically based on the other columns data in the same table, based on the below rules .
I have done the activity in excel, but unable to code it.
sample data image is attached.
- Promo ID: From System,
- Scheme ID: From System ( One Promo ID can have multiple Scheme ID )
- Min_Val: From System
- Max_Val: to be updated based on the above 3 columns
IF: (the next row Promo ID is the same then take the Min_Val -1 of it )
Min_Val - 1
in Excel : =IF(A2=A3,C3-1,500)