Do until loop (deleting duplicate values)

assuming your values are all in one column (not aa in column A, 12 in column B) and the text and numbers are always separated by a space, this should work for all selected cells:

Please Login or Register  to view this content.

Hi,
Thanks for replying. I should have been more specific. The variable populates one column and the values populate one or more columns.

Assuming you want to clear values from the duplicate cells, the following code should do what you want. To execute, anchor should point to the first cell in the list.

Please Login or Register  to view this content.

Regards, AB

Hi aussieboykie,

When I run it, I get a runtime error'424' object required and "With anchor.Cells(1)" is highlighted.

Originally Posted by buntalan80

When I run it, I get a runtime error'424' object required and "With anchor.Cells(1)" is highlighted.

Select the anchor cell (in your example that would be the first "aa" cell) then removedups anchor:=activecell or you can add a macro to do it..

Please Login or Register  to view this content.

Regards, AB

Hi NickyC,

I've attached a sample file to avoid confusion.
Thanks again.

ok, select the labels in column A and try this:

Please Login or Register  to view this content.

Thank you.

Hi,

I've similar problem but the desired result is different.
I've huge amount of data in multiple row and columns. The first column contains the unique data (Say Unique IDs) and are duplicated.
Now I want to remove duplicates for unique IDs on the basis of some particular values in other column.
For example, Column A is having unique IDs with duplicates and Column C is having values different values for each duplicate of particular IDs (Column A: 11,11,11 and Column C is : aa,bb,cc. I want Column A to contain unique 11 and column C say bb that I explicitly will mention)
I hope I tried to explain my requirement.


Thanks a lot in advance !




Data

112233 aa xyz mnc pqr
112233 bb sdw sdf wer
112233 cc aaa nma pre
224431 rr aaq asa dsa
224431 bb bsa sab nam
224431 cc rrr www apq
998873 aa ree tre uio
998873 bb bre bte tre
998873 rr bbnm bgy uyg
123345 ww rty iuu oiu
567654 pp try iuy opp
345621 bb yuyt kjh hbh




desired
112233 bb sdw sdf wer
224431 bb bsa sab nam
998873 bb bre bte tre
123345 ww rty iuu oiu
567654 pp try iuy opp
345621 bb yuyt kjh hbh

can you post an example?

Hi,

Thanks for taking interest and providing me the support!

I tried to project the example of my requirement as below

Data

112233 aa xyz mnc pqr
112233 bb sdw sdf wer
112233 cc aaa nma pre
224431 rr aaq asa dsa
224431 bb bsa sab nam
224431 cc rrr www apq
998873 aa ree tre uio
998873 bb bre bte tre
998873 rr bbnm bgy uyg
123345 ww rty iuu oiu
567654 pp try iuy opp
345621 bb yuyt kjh hbh

The data is what exactly I'm having with duplicate (See Col A). they are unique values but they are repeated in excel sheet.
I've to remove duplicate value of Col A based on the value Col B having. For example, somehow if I can put a condition that I want to keep all the unique values in Col A for value bb in Col B and delete all duplicates.

Then my desired result will look like below.

desired Result
112233 bb sdw sdf wer
224431 bb bsa sab nam
998873 bb bre bte tre
123345 ww rty iuu oiu
567654 pp try iuy opp
345621 bb yuyt kjh hbh

Thanks in advance!

is your information contained in one column, 2 columns or a column for each string of letters
how are you identifying which rows to keep and which to delete.
For example, do you keep only rows including "bb"? what happens if a number has more than one row with "bb" or none at all