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" <(E-Mail Removed)> wrote in message
news:1D832055-F84E-436A-B6F1-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:8239444A-546B-461B-AB5C-(E-Mail Removed)...
>> > 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
>> >
|
Similar Threads
