Hi everyone.
Looking for some help. I have a spreadsheet that contains the following...
Column A has repeated Order Numbers
Column B has the values associated with those repeated Order Number
For example:
Column A
1234
1234
1234
1234
1234
1235
1235
1236
1237
1237
1237
1237
1237
Column B
100
100
100
100
100
200
200
300
400
400
400
400
400
Here's what I'm looking for...
Is there a formula that can look at the repeated Order Numbers in Column A and sum the value of all of those repeated Order Numbers and place that total beside the first Order number record in lets say Column C?
And another formula that can look at the repeated Order Numbers in Column A and sum the value of all of those repeated Order Numbers less one Order Number record (as the first record is a true transaction) place that total beside the first Order number record in lets say Column D?
So for Order Number 1234, Column C should have a total sum for that order number of 500 and Coulmn D should have a total sum of only 100.
Any help with crafting a formula would be greatly appreciated.
Cheers!
Looking for some help. I have a spreadsheet that contains the following...
Column A has repeated Order Numbers
Column B has the values associated with those repeated Order Number
For example:
Column A
1234
1234
1234
1234
1234
1235
1235
1236
1237
1237
1237
1237
1237
Column B
100
100
100
100
100
200
200
300
400
400
400
400
400
Here's what I'm looking for...
Is there a formula that can look at the repeated Order Numbers in Column A and sum the value of all of those repeated Order Numbers and place that total beside the first Order number record in lets say Column C?
And another formula that can look at the repeated Order Numbers in Column A and sum the value of all of those repeated Order Numbers less one Order Number record (as the first record is a true transaction) place that total beside the first Order number record in lets say Column D?
So for Order Number 1234, Column C should have a total sum for that order number of 500 and Coulmn D should have a total sum of only 100.
Any help with crafting a formula would be greatly appreciated.
Cheers!