Filter and remove duplicates
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I have a file. Column A has all employee IDs and it has duplicate IDs since data is consolidated for different dates into one file. Now my requirement is to filter the data as per employee ID and remove the duplicates based on value in a different column. So I will put a filter in Column A and check the the values in Column G and remove the entire row if column G has duplicate value. Appreciate any help around this.
Thanks in Advance!
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Hermant86,
If I understand your use case correctly you should be able to use the unique tool. Configure it to identify a duplicate using both the ID column as well as the additional column. If this is an incorrect assumption of what you would like to accomplish please post a small sample of the data and identify a few "duplicates" and I can try again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes that is what I was expecting. The unique tool (in preparation) should get the job done for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Erica!....That does the job for me. This community is amazing.🙂
If I can ask for one more favor.
I need to consolidate a bunch of excel files placed in a folder. The number of files in the folder keeps changing. The files names are different and each file has a sheet with a different name. But the column headers and order is always constant. So I need to merge all the data into a single file. I tried something which I got online like using a wildcard in the path of the files to loop through all available files but it throws an error.
Appreciate if you can guide me on that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Anytime!
Don't forget to mark the solution as accepted so others can find it as well.
Please see the attached image for your next question. If the format is the same for all and they are in the same folder the wildcard should work. Just make sure you added the extension.
