hi, I am doing a project where I am entering all the file names of a folder in an excel sheet, but in the local folder, there are some files like (1.jpg, 1,pdf, 1.rar) while entering the filename into excel, I only want to enter one 1, not three times. how can I do that? filename.xaml (9.0 KB)

Hi @ArafatRakib1 , I have done some changes in your source file. File : filename.zip (2.5 KB) [image] Regards Balamurugan

Remove duplicate from excel

balupad14 (Balamurugan (BalaReva)) April 28, 2018, 10:29am 4

@ArafatRakib1,
I have done some changes in the code.

File : Duplicate.zip (7.5 KB)

Regards
Balamurugan

REmove duplicates from datatable excel

Topic		Replies	Views
Delete me thanks Activities excel , activities , question	3	679	June 19, 2022
If the cell contains the same NUMBER in Excel Help Studio studio , question	22	529	December 11, 2023
How can we avoid dupicates in excel i have only one header row? Studio studio , question , activities_panel	14	86	July 2, 2024
Remove Duplicates from Excel Help	10	2251	September 20, 2019
REmove duplicates from datatable excel Help datatable , activities , question	13	2692	November 14, 2019