LinkBack URL
About LinkBacks
Hi All
Please help me again on my problem. I need to compile names from 2014 - 2015 and come up a list that duplicate names are remove from the list. and the final list of names should be in column C.
Thanks.
Please see attachment for ref.
Auto Name Compiling and Sorting
Hi All
Please help me again on my problem. I need to compile names from 2014 - 2015 and come up a list that duplicate names are remove from the list. and the final list of names should be in column C.
Thanks.
Please see attachment for ref.
Should the duplicates be removed from both lists? I am confused by your request. Please clarify with examples of what you want done. It may be clear to you, but I am not understanding what you want.
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
Hi, Good Day.Originally Posted by alansidman
Sorry if I didn't explain my request properly.
It should come up with a result or output to column C that those duplicated names from column A and B will be record as one.
please see attachment. Thanks
I am still confused. In the result column, there are single names when the name is in both columns. There are duplicate names when they are in both columns. You need to be more specific about your criteria. I do not see a clear case of what is in Column C and why.
Thanks for quick reply
I want to create other listing which is in column C. The list of names that are not duplicated from 2014-2015.
Scenario.
if name1 are there in 2014 list but not in 2015 it should be added in output
if name2 are there in 2015 list but not in 2014 it should be added in output
if name3 are both in list 2014-2015 should be added in output.(means if duplicated from 2014-2015 it will add only one name3 to the output)
or
Macro that will remove all the duplicate names from list of one column and the output will be in other column.
thanks for helping
Last edited by 23inzane10; 11-08-2017 at 10:17 PM.
Hi 23inzane10
See if this Code in the attached does as you require...CTRL + g will fire the Code...
Please Login or Register to view this content.
Last edited by jaslake; 11-09-2017 at 12:05 AM.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
wow thanks it works great.. cheerss..
Hi 23inzane10
See if this Code in the attached does as you require...CTRL + g will fire the Code...
Please Login or Register to view this content.
Hi. Good Day!
I need help on this macro. How can i add new column that the info is connected to 2014 and 2015.
please see attachment.
Hi 23inzane10
You'll need to show me what you're looking for...I don't see it.
NVM master I solve it. thanks anyway..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks