In numbers how do I find duplicate names and add up the corresponding values
Posted on Jun 15, 2015 1:16 PM
Q: numbers find duplicates and add corresponding values in columns
A quick way to flag the duplicates is to do something like this:
In C2, copied down the column: =IF(COUNTIF($A,A2)>1,"duped","")
How do you want to add up the values? In this example would it be 15, or just 5 for the second occurrence?
SG
