animecarey
08-10-2010, 03:07 AM
Hi guys,
I'm really at my wits end with this problem. Hopefully someone can shed some light with this problem. I currently have rows of data which are divided into 7 columns. I need to do two things with this data.
One:
I need to search for different business ids located in column B.
Having located each unique ID, I need to sum up values which are located in column C. The problem is that I there are repeats which are located in column D.
Is there anyway I can create a code (Excel or VBA) to actually locate a business id, identify which are the unique values in column D and sum up the corresponding values in C?
Two:
Next thing I need to do is much simpler. I need to search for the different business ids located in column B and sum up values in column E. Copy these business ids and their summed up values into another spreadsheet. Can anyone help me?
I'm really at my wits end with this problem. Hopefully someone can shed some light with this problem. I currently have rows of data which are divided into 7 columns. I need to do two things with this data.
One:
I need to search for different business ids located in column B.
Having located each unique ID, I need to sum up values which are located in column C. The problem is that I there are repeats which are located in column D.
Is there anyway I can create a code (Excel or VBA) to actually locate a business id, identify which are the unique values in column D and sum up the corresponding values in C?
Two:
Next thing I need to do is much simpler. I need to search for the different business ids located in column B and sum up values in column E. Copy these business ids and their summed up values into another spreadsheet. Can anyone help me?