orlandomike
New Member
- Joined
- Feb 3, 2005
- Messages
- 1
I know this has to have been asked 1000 times but here goes another.
I know you can use advanced filtering to delte duplicate rows but they will only be seen as duplicate if all the columns in each row is the same.
I want to take a table of several columns, sort it off of one of those columns, for example client name, Any time the clients name is duplicated, all rows containing that name will be deleted. (except one of course.)
example:
Smith South Street Florida
Jones North Street Florida
Smith South St. Florida
Under advanced filtering the extra smith row wouldnt be deleted as it isnt an exact match. I want to delete that row.
Thanks.
I know you can use advanced filtering to delte duplicate rows but they will only be seen as duplicate if all the columns in each row is the same.
I want to take a table of several columns, sort it off of one of those columns, for example client name, Any time the clients name is duplicated, all rows containing that name will be deleted. (except one of course.)
example:
Smith South Street Florida
Jones North Street Florida
Smith South St. Florida
Under advanced filtering the extra smith row wouldnt be deleted as it isnt an exact match. I want to delete that row.
Thanks.