Hi.
I have a huge data in excel like the one in the image link below:
Sample_tgg2xp.jpg
I need to know which part of the receipt 450.00 (cell C8) belongs to D3, D4, D5 cells and etc. beginning from the first non-zero cell in D column, so that to find currency difference effect within 450.00 (C8) like the following: (200.00)*(1.80-1.98)+(450.00-200.00)*(1.86-1.98) or if we have 50.00 instead of 450.00 just to make calculation like this: (50.00)*(1.80-1.98).
I just can't imagine how to do it using formulas and I don't know VBA. So it is very much appreciated if anyone can help me with this issue either via excel formulas or macro.
Bookmarks