2 Replies Latest reply on Oct 28, 2016 1:19 AM by Leslie Raillon

    Formula to detect when a value is repeated

    Leslie Raillon

      Hi

       

      I have a database that looks like this:

       

        

      Date Setuporder_id
      420139259
      420159266
      420219277
      420169278
      420149280
      420139281
      420169282
      420129284
      420159285
      420219287
      420279287
      420739287
      424449287

       

       

      I what a formula that identifies when order id is repeated (because in fine I will want to remove them).

       

      Any tips to do that?

       

      I was thinking at a IF formula that says 1 of repeated 0 if not for instance

       

      Thanks a lot for your thoughts

       

      Regards

       

      Leslie