Find duplicate order IDs, then add shipping together (several columns to the right)

"A picture is worth a thousand words..."

Not on an Excel forum! Practically worthless! Kindly consider uploading an actual workbook.

Regards

Just as an idea. In C2 and copy down

Formula:

Please Login or Register  to view this content.

Hello Fotis,

Many thanks for the input...my apologies - I've confused you ....the final column with the <- in it was just for commenting purposes.

I therefore removed the "<-" aspect of your formula - it almost works (thanks )....indeed it does work if there are only two duplicates, but if there are three or four duplicate...the totalling of the associated shipping doesn't work. (I should have said there may be duplicates in twos, threes...possibly as high as eight duplicate entries in column A ...alas the number of duplicates will be random & not know beforehand).

I've attached an example with scenarios that I mention (ie where more than one duplicate exists that all need totalling)...it'd be great if you could mull it with a view to a solution :-)

regards,
Hank.

Hi,

So you only want results to appear if the Order ID appears more than once in that column?

If so, in C2 and copy down:

=IF(COUNTIF($A$2:$A$40,A2)=1,"",SUMIF($A$2:$A2,A2,$B$2:$B2))

Regards

Perhaps

Formula:

Please Login or Register  to view this content.

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Actually, I've just noticed that for all the proposed solution does indeed total up duplicate order ID postages in column B, the solution unfortunately ignores any postage that aren't duplicate order IDs (therefore there's nothing in the final column - my fault for not being specific enough!)

Can that formula can be tweaked to place whatever postage total is (duplicates or not) into column 'C'

Therefore if there are duplicates order IDs (column A) ....add the postages for the same order ID together ....if there aren't any duplicate order IDs, then just place the related postage value into the final column ...ultimately I seek one column which has the correct postage totals for each order.


Example file attached.

Many thanks!