Hi Sundarvelan, I don't know how to do this without VBA because of the duplicates, sorry.
Regards - Dave. Date: Mon, 9 Aug 2010 22:58:21 +0530 Subject: Re: $$Excel-Macros$$ Excel VBA : Unique Values From: nsund...@gmail.com To: excel-macros@googlegroups.com Thank you So much!!! Dave. Could you help me to find one more task. I need to list TL names under each Manager Name. Please help me. I haev attached the revised Excel file for your work. Thanks, sundarvelan On 8/8/10, Dave Bonallack <davebonall...@hotmail.com> wrote: Hi Sundarvelan, Have a look at the attached. I have done this with worksheet functions, but it may be better done with VBA. However, it has highlighted the fact that you have some duplicate rows in your basic data. I have coloured the first instance of each duplicate row in green, and the second instance in yellow. You will see that I've done the same in Columns AE and AM. If the duplicates are intended (and not an error) then I think I would have to do it again, but with VBA, to prevent the duplicates showing up in the lists. Regards - Dave. Date: Sat, 7 Aug 2010 15:56:26 +0530 Subject: Re: $$Excel-Macros$$ Excel VBA : Unique Values From: nsund...@gmail.com To: excel-macros@googlegroups.com CC: imran...@gmail.com Hello Friends, Under each TL name i need to get all the corresponding agents names. Please help me. Thanks, Sundarvelan On Sat, Aug 7, 2010 at 12:03 AM, Neeraj Lamba <neeraj96...@gmail.com> wrote: Sundarvelan, Uploaded a file in http://groups.google.com/group/excel-macros/files with Team+List_Home.xls name. This will add new name automatically when you add name in your data. Does any one help me? I am not getting option to upload file in post? How & From where I can upload in post directly? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- N.Sundarvelan -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- N.Sundarvelan -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
