LinkBack URL
About LinkBacks
tharindudk 
Hi,
I have a table with some data. I want to filter duplicate names for each sitee. I have explained what i want to do in excel sheet attched bellow. Any help is much appriciated.
Thank you
Hi,
I have a table with some data. I want to filter duplicate names for each sitee. I have explained what i want to do in excel sheet attched bellow. Any help is much appriciated.
Thank you
You can create a helper column with countif to see if it is a duplicate?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
HI,
Is there a way to writein a propper way. because what i am trying to do is scan range between site_1:site_2, Then site2:site3 etc.
Range("Site_Name_" & x:Site_Name_" & x+1.Offest(-1,0).Select
Hi tharindudk,
Perhaps you should edit your example?
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks