I’ll be importing two columns of spreadsheet, one which is client names and changes slightly month to month, and the second column which is commission received from each client, and I need to make sure the numbers stay with the respective client.
IE: Mr Bloggs $16.72 Mr James $33.19 Fox & Fox $20.21
And the next month it could be: Mr Bloggs 20.89 Mr James $30.33 Mrs New $5.91
I want to be able to clearly see if the amount relating to the respective client is significantly different from the past month (ie > or <$10 difference - indicating a possible issue or error that would need to be followed up on). I was worried about trying to make a formula that wouldn’t be able to take into account if a new person was in the column, and mess up the numbers etc. Any thoughts would be welcome!