I need to create a string for excel that will include all the criteria.
If previous months % premium (sheet 1 column c) is less than this months %premium than apply the % lift (sheet2 D3) to the % of premium (column c) in this month to the number of VDPS (sheet2 column b). If the previous months % premium (sheet 1column c)is greater than this month than back out % lift(sheet2 D3) , if equal than leave the same. All this needs to be matched on owner ID
I have attached a workbook to helpforum.ozgrid.com/index.php?attachment/69062/