Look for duplicated & unique values in adjacent column. Perform math on result. . .

Col A has wire part numbers. Many are duplicated.
Col H has wire lengths for those part numbers. Some lengths may be duplicates for the wire part number. (by design)

In another column, I'm using SUMIF to calculate the total wire length used for each wire type.

The problem: Need to look at the col A part number, and if a length for that part number is duplicated or just has a single instance, I need to multiply a single instance of that piece of wire by 2.

Example:

(source data)
Wire 1 length 12
Wire 1 length 12
Wire 1 length 15
Wire 2 length 6
Wire 3 length 55
Wire 3 length 20

Result:
SUMIF column: (SUMIF(A:A,wire_fromA,H:H))

Wire 1 Length 39
Wire 2 length 6
Wire 3 length 75

Setup Column (the problem column) (sum of unique lengths for that part number multiplied by 2.)
Wire 1 length 54
Wire 2 length 12
Wire 3 length 150


Thanks for any help obtaining a setup value. Plenty of room for helper columns. I tried creating unique values by combining col A and col H, counting the instances. . . but don't exactly know if that might contribute to a correct approach.

Peter

Awesome!!!!!

Thank you dafodil11 and of course to Mr. Tony Valko.

Peter

Glad I could help out.


Feel free to mark the thread as Solved under the Thread Options at the top of the page so others can search for this solution as well.