1 Reply Latest reply: May 15, 2014 10:11 AM by Olly Bond RSS

    Duplicate names

    dblevins _

      want to delete duplicate names in column 1 but roll up and sum the deleted rowsto the oine kept.....

        • Duplicate names
          Olly Bond

          want to delete duplicate names in column 1 but roll up and sum the deleted rowsto the oine kept.....[/QUOTE]

           

          Hello dblevins and welcome,

           

          You can do this easily in Monarch using a summary.

           

          Define the field in column 1 as the Key field, and use count() as the Measure to get started.

           

          You can add more key or item fields later, as well as more sophisticated measures.

           

          HTH

           

          Olly