Remove duplicate from excel

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

1 Like

there is an another small problem. some filename value is decimal number so excel is cutting down the last digits after last 4 digit.

but i need the exact value.

@balupad14

1 Like

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

File : Duplicate.zip (7.5 KB)

image

Regards
Balamurugan

for me it is not working it say filename access denied