I have a case where I want to add data to a row, from another row if the numbers matches. I could try to write it down in text but I think it is easier to give the example right away (we always have a maximun of 3 columns to start with)(1,2 and 3 are just row-numbers, not data in cells):
A B C
1 11 12 13
2 13 14 15
3 20 21 13
End-product
A B C D E
1 11 12 13 14 15
2 13 14 15
3 20 21 13 14 15
So if column C equals column A, I want the data from column A to be added to row 1 (in the first case). It should then find all the instances where this adds up so that everything (from this example) will have the number 15 in the end (since this is the end-number in this case). I also want this to continue to happen since I want the end number to always be 15, so if there is a case where we have add the numbers twice to get to 15, then we should do that. I will give an example below to clarify what I mean here:
A B C
1 11 12 30
2 13 14 15
3 30 31 13
A B C D E F G
1 11 12 30 31 13 14 15
2 13 14 15
3 30 31 13 14 15
Side notes: I do not want it to add row 1 to row 2 (since it will match that way too), in other words it should always add the data from column A.
And I do realize it might have been a douche move to make 15 the end number, and not the highest one, but this is the case in my siutation so I just wanted to make it clear that it just not a matter of arranging the numbers either.
I hope I was able to explain myself somewhat, I will be happy to clarify if anything is unclear.
