Hello together,
looking for a formula, really hope you can help me out. You can find the example file attached, here's the case:
Target:
complete column G contains the same formula
only in the green marked fields (G3, G8, G13, G19, etc) appears a value, the remaining yellow fields remain blank "" (G4-7, G9-12, G14-18, etc.)
value in column E can only be considered 1 time
general Condition for the formula:
to be calculated: value in column E minus value in column F (E3-F3=G3)
if column A, C and E are equal in the following rows, only the value in column F should be counted (means column E can only be used for calculation once) = if A3 and C3 and E3 equal A8 and C8 and E8 then F3=G3
there can be multiple entries (no limitation) with the same information of column A, C and E
If the values of column A, C and E are blank, column G also should be blank
important:
between the entries are different amounts of rows considered (for example line 3 to line 7 = 4 rows; line 13 to line 18 = 5 rows)
-> can vary between only 2 rows up to 10 rows difference
I hope the problem is understood and I hope you can help me out!
Thanks a lot!
Bookmarks