Hi Kasper, Dear instead of giving solution i just want to give the idea required to accomplish your task.just follow the below mentioned steps and it help you to do it from your own.
1:Select the columns of employee name . 2:click : Data Tab 3: Spot the option : Remove duplicate 4: it will ask extend your selection or continue with selection 5:Choose Continue with selection 6:And thats it. Note:if you want this unique data to be displayed in some other column then select your whole data and copy it some other place then follow above steps and paste the result at the required place Regards Prince On Tuesday, January 1, 2013 6:30:24 PM UTC+5:30, kasper wrote: > > > > > > Hi Experts, > > Please refer the attached file & tell me > How to select employee names from the column "B" and display in Column "D" > after removing the duplicate. > > Regards > Rajesh > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
