Dear All
This is my first post! Hope someone can help.
I would like to know how to automatically delete rows if a particular cell in that row is a duplicate.
My 'A' column has a number of duplicates in it. If the cells in this column are duplicates I need to delete the whole row corresponding to that cell. Only this particular cell is a duplicate in the row - the other cells may not be duplicates.
Hope this makes sense - I would be really greatful for any help
Rachael
This message was edited by rachaelb on 2002-05-08 08:46
This is my first post! Hope someone can help.
I would like to know how to automatically delete rows if a particular cell in that row is a duplicate.
My 'A' column has a number of duplicates in it. If the cells in this column are duplicates I need to delete the whole row corresponding to that cell. Only this particular cell is a duplicate in the row - the other cells may not be duplicates.
Hope this makes sense - I would be really greatful for any help
Rachael
This message was edited by rachaelb on 2002-05-08 08:46