Hi,
I would very much appreciate the help with the following;
In the image above, all information in row 3 and 4 are the same except for column J (the amount).
In row 5, the information is unique (hence the doubles count N in the check field that I have created a formula for in column N).
My question is; how can I create a macro or a formula that ensures that when data in field B to I is the same, the amount should be summed up in 1 row instead of two seperate rows.
The reason I need to this is because the program in which I then load the data can only accept one row for each unique "string".
It should also be said that there is no way for me to predefine the strings (for example, a new profit center could be added next month), which is why I can not create a SUM-formula for all potential strings.
Much appreciated!
I would very much appreciate the help with the following;
In the image above, all information in row 3 and 4 are the same except for column J (the amount).
In row 5, the information is unique (hence the doubles count N in the check field that I have created a formula for in column N).
My question is; how can I create a macro or a formula that ensures that when data in field B to I is the same, the amount should be summed up in 1 row instead of two seperate rows.
The reason I need to this is because the program in which I then load the data can only accept one row for each unique "string".
It should also be said that there is no way for me to predefine the strings (for example, a new profit center could be added next month), which is why I can not create a SUM-formula for all potential strings.
Much appreciated!