I need to generate some code that will :
For every unique entry in column(A) that has "Connection" in column(C). <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
And has 3314 in column(V): <o></o>
And in one of the lines above; column(C) = "Messages", <o></o>
<o></o>
Subtract the value in the column(D) on the line that contains "Messages" from the value in column(D) on the line which Item column(C) = "Connection". = X
On the line that contains "Connection" Subtract column (F) from X. = Y <o></o>
Then on the line that contains "Connections" Multiply Y by the column (H) and paste into the column (U). <o></o>
Repeat for all unique entries in column (A).<o></o>
<o></o>
TIA
Bob
For every unique entry in column(A) that has "Connection" in column(C). <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
And has 3314 in column(V): <o></o>
And in one of the lines above; column(C) = "Messages", <o></o>
<o></o>
Subtract the value in the column(D) on the line that contains "Messages" from the value in column(D) on the line which Item column(C) = "Connection". = X
On the line that contains "Connection" Subtract column (F) from X. = Y <o></o>
Then on the line that contains "Connections" Multiply Y by the column (H) and paste into the column (U). <o></o>
Repeat for all unique entries in column (A).<o></o>
<o></o>
TIA
Bob
Last edited: