LinkBack URL
About LinkBacks
Can you please help me
I have lots of records in different row
I need to delete the duplicate cells form them
ie
R1 : 1,2,3,1,3,5
R2: 2,1,6,2,4,5
it is requiered to be like this
R1: 1,-,3,-,5
R2: 2,-,6,-,4
where - is emply cell
Can you please help me
I have lots of records in different row
I need to delete the duplicate cells form them
ie
R1 : 1,2,3,1,3,5
R2: 2,1,6,2,4,5
it is requiered to be like this
R1: 1,-,3,-,5
R2: 2,-,6,-,4
where - is emply cell
attach please a sample file with data and desired result
If solved remember to mark Thread as solved
Hi, amkoloui,
you would need to explain if teh guess fo first going through Column A is correct as I would have the result to be different from what you show up (first work the row and then the column leading to a different result of figures at different places).
Generally spoken itīs a loop to go through the cells and use WorksheetFnction.CountIf with the range passed and clearing the contents if the result is greater 1 but we would need to know how to proceed (if itīs going through the rows first a For Each...Next could be used, if itīs the Columns first 2 loops would be needed).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
it is uploadedOriginally Posted by patel45
I Had some search in the net and found some macro useful
To arrange the date in one column
but it dose not arrange the list or delete the duplicate
how i can modify this to arrange the result and delete the duplicate
http://www.extendoffice.com/document...column.html#a2
Please Login or Register to view this content.
Last edited by amkoloui; 02-15-2014 at 12:02 PM.
Hi, amkoloui,
you would need to add code-tags around your procedure according to Forum Rule #3 before anybody would be able to answer to this thread.
Ciao,
Holger
Hi, Holger
Is it done ?
Last edited by amkoloui; 02-15-2014 at 11:57 AM.
where is desired result ?
i need to arrage these data in one clumn and remove the dublicated
This is the data sample with the desired result
Regards,
Ahmed EL Koloui Data Sample desired result.xlsmData Sample desired result.xlsm
try this code
Please Login or Register to view this content.
HI , Patel ,
Unfortunately this code do not work correctly
It leaves some duplicate data
The code i copied is copying all the data in a selecting range
then
selecting the target data and past it
but it do not remove the duplicate or arranging the records
Hi Amkoloui,
Try the attached.
or
editedPlease Login or Register to view this content.
or
Please Login or Register to view this content.
Last edited by nilem; 02-15-2014 at 01:47 PM. Reason: add option
Hi Niem,
I was doing system collection code to avoid sorting the data, but you beat me to the line.
Thank You Niem,
The Sub ertert2 works perfectly
Thank You
Hi Ahmed,
You are welcome!
The Sub Updatemine from AB works well too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks