Hi all, i think i'm having a senior moment and need some assistance plse.
im using excel 2016, i have a data set that will possibly change from week to week and i'm trying to track the changes on certain things. On my raw data table i have added previous status and previous amount. i have copied the data from the previous week in to a separate sheet within the workbook and here comes my senior moment...i cant for the life of me think what i need to do next to track the change, if any....
Column A is an id field, col B is opp/lead. i want it to look at column A to see the id, then look at column b and see if it says oppy or lead then look at previous week to see if the same id says either oppy or lead and to see if the $ amount has changed from the previous week
ID oppy/lead. Amount previous week previous week amount
1234 oppy 50,000 lead 75,000
5678 oppy 50,000 lead 40,000
abcd lead 50,000 lead 50,000
so i can see on the example that id 1234 was previously a lead for 75K but this week its changed status to an oppy but dropped by 25K, where as id 5678 changed from a lead to an oppy but increased by 10K
any help appreciated.....
Thanku
Lizzi
im using excel 2016, i have a data set that will possibly change from week to week and i'm trying to track the changes on certain things. On my raw data table i have added previous status and previous amount. i have copied the data from the previous week in to a separate sheet within the workbook and here comes my senior moment...i cant for the life of me think what i need to do next to track the change, if any....
Column A is an id field, col B is opp/lead. i want it to look at column A to see the id, then look at column b and see if it says oppy or lead then look at previous week to see if the same id says either oppy or lead and to see if the $ amount has changed from the previous week
ID oppy/lead. Amount previous week previous week amount
1234 oppy 50,000 lead 75,000
5678 oppy 50,000 lead 40,000
abcd lead 50,000 lead 50,000
so i can see on the example that id 1234 was previously a lead for 75K but this week its changed status to an oppy but dropped by 25K, where as id 5678 changed from a lead to an oppy but increased by 10K
any help appreciated.....
Thanku
Lizzi