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)

Remove duplicate from excel

balupad14 (Balamurugan) April 28, 2018, 1:29am 2

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

Regards
Balamurugan

1 Like

How to remove duplicate data?

Topic		Replies	Views
Remove Duplicates from Excel Help	10	1831	September 20, 2019
Duplicate item count Help activities	2	2009	December 25, 2018
Copy files with same name in a location Activities excel , activities , question	3	564	November 15, 2022
How to remove the duplicate Integer data in excel sheet Community question	13	677	January 28, 2021
How to remove duplicate entries from excel file Studio uiautomation	6	652	October 22, 2022