How to remove/avoid duplicate data in Spreadsheet

 
1
0
-1

I have one spreadsheet to insert data into database, the primary key {id} is created by SQL. But I want to remove/avoid duplicate data in Spreadsheet. Because the id is different, other column is the same also can be insert successfully. The same record should be removed obviously. 

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Thanks for this such an excellent post! Keep up! bad love story

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi, if the primary key ID is created automatically, then how would you know whether data is duplicate or not? If you want to avoid such duplicates then I do not think you can use auto-generated IDs.

          CommentAdd your comment...