Hi! Iam working on an excel, where I have the same column value repeated. I would like to get only the first occurance or remove the rest of the occurance. Any leads pls?

Hello Balamurugan, Thank you for the suggestion. I used Datatable.DefaultView.ToTable(True,“”), and this worked perfectly!

How to remove the duplicate column values in an excel

balupad14 (Balamurugan) January 20, 2020, 6:43am 2

Have you tried this ?

Regards
Balamurugan.S

1 Like

Topic		Replies	Views
Excel Duplicate Value Activities datatable , excel , activities , studio , question	1	321	June 16, 2023
Remove duplicate rows from a column Help excel , activities	6	4782	January 26, 2019
If there are identical numbers in Excel, display only one Help me Studio	16	360	December 1, 2023
Duplicate Delete Activities datatable , excel , activities	4	779	November 23, 2021
Remove Duplicates Specific Column Help datatable , activities , question	9	2525	January 17, 2020