NYCpal Posted February 1, 2022 Report Share Posted February 1, 2022 How to make a list of duplicate records in a large dataset. Quote Link to comment Share on other sites More sharing options...
workless_barber Posted February 1, 2022 Report Share Posted February 1, 2022 4 minutes ago, NYCpal said: How to make a list of duplicate records in a large dataset. first select the few rows you want to duplicate define a name by right click selection in different the cell give =(defined name) Quote Link to comment Share on other sites More sharing options...
NYCpal Posted February 1, 2022 Author Report Share Posted February 1, 2022 1 minute ago, workless_barber said: first select the few rows you want to duplicate define a name by right click selection in different the cell give =(defined name) I wanted to make a list of duplicate records already exists in the dataset Quote Link to comment Share on other sites More sharing options...
workless_barber Posted February 1, 2022 Report Share Posted February 1, 2022 17 minutes ago, NYCpal said: I wanted to make a list of duplicate records already exists in the dataset concatinate all the columns data in to new column and take sub total if any subtotal is greater than 1 that is duplicate 1 Quote Link to comment Share on other sites More sharing options...
37,886
-1.thumb.png.613bdd33b4e8b5f69ac815bf90e62a8b.png)
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.