|
Deleting Duplicate Rows containing a value matching with a value f
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 |
Deleting Duplicate Rows containing a value matching with a value f
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 |
Deleting Duplicate Rows containing a value matching with a val
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 |
Deleting Duplicate Rows containing a value matching with a val
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 |
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 |
| All times are GMT +1. The time now is 12:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com