1. Corrected the cell to column or reference variable, test data and expected results in the below question posted. 2. There will be different unique id's , Each unique id is linked to tier and tier will have certain discount, minimum amount and maximum amount I have Data like below: UniqueID tier disc min_amt max_amt adj_amt_min 1 5 28 1278 2055 1 4 25 849 1295 1 3 25 545 794 1 2 20 369 520 1 1 19 320 320 2 5 25 1400 2095 2 4 24 749 1395 2 3 23 545 794 2 2 23 349 520 2 1 12 330 330 I did group by unique id I need to iterate from the top to bottom and update the adj_amt_min by comparing in below way. 1. If 1st row third column 'min_amt' value is less than the 2nd row fourth cell value then adj_amt_min should be set as 2nd row fourth column 'max_amt ' value else values for adj_amt_min should be same as min_amt. 2. If 2nd row third column 'min_amt' value is less than the 3rd row fourth cell value then adj_amt_min should be set as 3rd row fourth column 'max_amt ' value else values for adj_amt_min should be same as min_amt. 3. If 3rd row third column 'min_amt' value is less than the 4th row fourth cell value then adj_amt_min should be set as 4th row fourth column 'max_amt ' value else values for adj_amt_min should be same as min_amt. 4. If 4th row third column 'min_amt' value is less than the 5th row fourth cell value then adj_amt_min should be set as 5th row fourth column 'max_amt ' value else values for adj_amt_min should be same as min_amt. 5. For fifth row the values for adj_amt_min should be same as min_amt. My output should look like this: In the above data we found that in first row 3rd cell is less than the second row 4th cell value, so here in the first row for adj_amt_min will be set as 2nd row 4th cell value UniqueID tier disc min_amt max_amt adj_amt_min 1 5 28 1278 2055 1295 1 4 25 849 1295 849 1 3 25 545 794 545 1 2 20 369 520 369 1 1 19 320 320 320 2 5 25 1400 2095 1400 2 4 24 749 1395 794 2 3 23 545 794 545 2 2 23 349 520 349 2 1 12 330 330 330
... View more