7 Replies Latest reply: Aug 1, 2017 7:44 AM by Phil Speight RSS

    Anonymise Names with Unique Ref

    Phil Speight

      Hi

       

      I want to replace a name with a unique reference number.  Is this possible?

       

      see example below

       

       

      DateNameAmountAnnon
      01/04/2017Sam Smith1001234
      02/04/2017Joe Bloggs505678
      02/04/2017Sam Smith1501234
      03/04/2017Peter Potter209876
      03/04/2017Joe Bloggs1005678

       

      I want to create 'Annon' column based on the name See above.

       

      Any thoughts?

       

       

       

      Regards

       

       

       

      Phil