Has anyone here knows how to facilitate these actions? I wish the data in Sheet1 column I to be filtered and removed the duplicate names. Filtered data then to be moved to another sheet (Sheet2 col A) following the font type and size and cell color formatting.
Thanks in advance!
When duplicates are found in Column I, do you wish that the entire row of data for the duplicates to be removed from the sheet? A bit confused by your explanation. In your title you refer to delete duplicates but you also refer to filter them. Which is it? Filter or delete? They are not synonymous terms.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Sorry for the confusion. The idea is to filter the data and delete the duplicate names when it moves to Sheet2. But, I want the data in Sheet1 to remain intact when the task is performed.
Try
Please Login or Register to view this content.
Perfect! Thanks Jindon. Can it also be possible to follow the formatting same on what is shown in the sample template?
Add one line
Please Login or Register to view this content.
Thanks again, Jindon.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks