mrSupernoob
New Member
- Joined
- Jan 4, 2017
- Messages
- 2
Hi everybody.
This might be a silly question but I have not yet found an answer with googling. Might be that I have incorrect search terms etc. but I really need some help
I have an assignment that requires me to produce a excel tool for comparing several attributes / differences in a data set that is produced each week. A sort of customer account data that needs to be checked for changes and one column of data needs to be extracted and produced to a list differentiated with commas and empty spaces removed.
These are account numbers where there is a number on column A and other customer information on other columns (from B to I).
So I have these steps that I need to do:
1. Every week I have to compare the data output from this week to the last to see if there are changes. The customer accounts can be "closed" and this is marked in a separate column. These rows that have a date marked on one column have to be located and deleted from the data set.
2. I have to see if there are new accounts added to the list. These have to be added to the list with just the account numbers.
3. I also have a list of client names (on a seperate excel file). I have to cross check the list so that no client has been dropped completely from the list / or if there is a new account on the account name list but they don't have any accounts on the account list (my main excel file).
I would strongly prefer a solution that would need as little as possible manual work. The file has about 1500 rows of data so any manual effort will be quite uhm... inconvenient.
Hopefully I have explained the problem so that it makes even slightly sense and I'll gladly answer to any questions about more details. Unfortunately I cannot post you the file since it contains sensitive client information. Thank you in advance!
Best regards,
mrSupernoob
This might be a silly question but I have not yet found an answer with googling. Might be that I have incorrect search terms etc. but I really need some help
I have an assignment that requires me to produce a excel tool for comparing several attributes / differences in a data set that is produced each week. A sort of customer account data that needs to be checked for changes and one column of data needs to be extracted and produced to a list differentiated with commas and empty spaces removed.
These are account numbers where there is a number on column A and other customer information on other columns (from B to I).
So I have these steps that I need to do:
1. Every week I have to compare the data output from this week to the last to see if there are changes. The customer accounts can be "closed" and this is marked in a separate column. These rows that have a date marked on one column have to be located and deleted from the data set.
2. I have to see if there are new accounts added to the list. These have to be added to the list with just the account numbers.
3. I also have a list of client names (on a seperate excel file). I have to cross check the list so that no client has been dropped completely from the list / or if there is a new account on the account name list but they don't have any accounts on the account list (my main excel file).
I would strongly prefer a solution that would need as little as possible manual work. The file has about 1500 rows of data so any manual effort will be quite uhm... inconvenient.
Hopefully I have explained the problem so that it makes even slightly sense and I'll gladly answer to any questions about more details. Unfortunately I cannot post you the file since it contains sensitive client information. Thank you in advance!
Best regards,
mrSupernoob