Combining cells to identify duplicates








CORP PR – PD 04/15       (9,385.26)
CORP PR – PD 04/15       (1,861.22)
CORP PR – PD 4/19 ADD            229.94
ADP INC      11,246.48

 

I am using Excel 365…in this example I would like to (1)identify the duplicates in Column A, which are “negative values”, then (2)combine their coresponding values in column B….then I need to identify the coresponding “positive value” in column B…. in the example above….(9385.26)+(1,861.22)= (11246.48)…coresponds to positive 11,246.48

By: Matt Hogg

Leave a Reply

Your email address will not be published. Required fields are marked *