Re: Filtering Out Duplicates
I used Marks method when I needed to do this and it worked great.
If you decide to go the Excel route, you can also go to the Data Tab and there is a remove duplicates button. It asks which columns to look at, and you an select there the parameters.
After you remove duplicates, you can create an extra column called Keep This Record, and set them all to 'True'.
When you reimport back into QB, have QB create a new checkbox column for keep this record. Filter by that checkbox and delete the non checked.
The excel solution is a one time solution, whereas Marks solution you can always go back and see if somehow you have new duplicates, so I think his is worth the effort.
------------------------------
Mike Tamoush
------------------------------
If you decide to go the Excel route, you can also go to the Data Tab and there is a remove duplicates button. It asks which columns to look at, and you an select there the parameters.
After you remove duplicates, you can create an extra column called Keep This Record, and set them all to 'True'.
When you reimport back into QB, have QB create a new checkbox column for keep this record. Filter by that checkbox and delete the non checked.
The excel solution is a one time solution, whereas Marks solution you can always go back and see if somehow you have new duplicates, so I think his is worth the effort.
------------------------------
Mike Tamoush
------------------------------