Deleting Duplicate Rows containing a value matching with a val
Thank you very much.
It is great. Works!
Thank you
Emil
"Patrick Molloy" wrote:
if the values in F are sorted, then starting at the bottom, ie the
highest/largest row number , if the data in the cell in the next lower row
matches , then delete the row
for rw = range("F1").End(xlDown).Row to 2 step -1
if cells(rw,"F")=cells(rw-1,"F") then
rows(rw),delete
end if
next
"emil" wrote in message
...
Hello
Patrick Molloy
Thank very much for your answer.
Delete Duplicate Rows
I believe that my question was not clear.
Here is an e.g.
I have a column (F: F) with the values as strings:
Range (F1).value = Str1
Range (F2).value = Str1
Range (F3).value = Str1
Range (F4).value = Str1
Range (F5).value = Str2
Range (F6).value = Str3
Range (F7).value = Str3
Range (F8).value = Str3
- At the first running of procedure, Cell (A1) has, the value Str1,
and
I will to erase the rows, which has the duplicates as Str1 in column
(F:
F).
- At the second running of procedure, the value in Cell (A1) changed to
Str2. Because I have no duplicates in column (F: F) for Str2, do not
erased any rows.
- At the third running of procedure, the value in Cell (A1) changed to
Str3 and I will to erase the rows, which has the duplicates as Str3 in
column (F: F).
And so on, systematically.
How can I do this?
I thank once again for granted time!
Emil.
"Patrick Molloy" wrote:
the key is how do you define a duplicate row?
i already answered a similar question.
my method was to add a key column which was the concatenated values of 10
columns. then we removed lines where we had duplicate keys.
think on this approach
"emil" wrote in message
...
Delete Duplicate Rows containing more values matching with a value from
a
cell located in other Range.
I searched the answer on Site http: Www. Cpearson.com Excel
distinctvalues.
Aspx, as well as in another questions from this forum but I did not
found
the
answer.
Thanks for any helps
Emil
|