Remove duplicate from excel


#1

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)


#2

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

image

Regards
Balamurugan


#3

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


#4

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

File : Duplicate.zip (7.5 KB)

image

Regards
Balamurugan