Dear Steve, You are most welcome..!!
Regarding good videos or tutorials for using Excel, I do not have such
material.
My suggestion would be use google or other search engines to find / download
learning material(s).
Best Regards n Very Happy New Year.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 1/1/10, sca...@aol.com <sca...@aol.com> wrote:
>
> Dilip,
>
> That's great, exactly what I was looking for. Now I can sort through
> 30,000 lines of data and look for gang members to go out and put in jail on
> their warrants.
>
> Do you know of any good videos or tutorials for using Excel? I can use
> some of the basic Excel functions but the macros and advanced stuff is a
> mystery to me. Is there any source you can recommend?
>
> Thanks,
> Steve
>
> In a message dated 1/1/2010 5:03:59 A.M. Eastern Standard Time,
> dilipan...@gmail.com writes:
>
> Dear Steve,
>
> Happy New Year....!!
>
> Attached file has been solved as per your requirements.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 12/29/09, sca...@aol.com <sca...@aol.com> wrote:
>>
>>
>> Here's a trimmed down version of what I'm looking at. I can pretty easily
>> get it in this format whenever I need to run through the lists. The
>> "warrants" tab is a list of people with warrants, the "gang member" tab is a
>> list of gang members. I'm looking for names in common to both lists (i.e.
>> gang members with warrants). Is is very possible for someone to be listed in
>> the "warrants" tab multiple times (they have more than 1 warrant) but the
>> gang member list should be sorted out and there should not be any duplicates
>> on there.
>>
>> If possible, I'd prefer the indication of who is on both lists to show up
>> on the "warrants" tab but that's not a big deal.
>>
>> Prior to pasting them on here I can also sort them by name or dob and get
>> them in order first if that helps.
>>
>> Thanks,
>> Steve
>>
>>
>>
>> -----Original Message-----
>> From: Dilip Pandey <dilipan...@gmail.com>
>> To: sca...@aol.com
>> Cc: excel-macros@googlegroups.com
>> Sent: Mon, Dec 28, 2009 5:26 am
>> Subject: Re: identifying duplicates
>>
>>
>> Dear Steve,
>>
>> Yes, it would be helpful if you move both the list in same workbook, under
>> two worksheets (Tabs).
>> Let me know if you face any challenge.
>>
>> Best Regards,
>>
>> --
>> DILIP KUMAR PANDEY
>> MBA-HR,B COM(Hons.),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 110062
>>
>>
>>
>> On Mon, Dec 28, 2009 at 2:23 AM, <sca...@aol.com> wrote:
>>
>>
>>
>> Wow. Let me see if I understand how this works.....
>>
>> I open "member list" and paste all my sublist people in there. Then I
>> name by big list "master list" and put them in the same directory? Then
>> just look at 'member list" and look for the 1's?
>>
>> Would it be easier if I kept them in the same workbook and just pasted the
>> master list to one tab and the member list to the second tab? The master
>> list will be about 26,000 lines, the member list will be about 5,000 lines.
>>
>> Thanks,
>> Steve
>>
>>
>>
>>
>> In a message dated 12/27/2009 10:18:15 A.M. Eastern Standard Time,
>> dilipan...@gmail.com writes:
>>
>> Dear Steve,
>>
>> To identiy the duplicates between the two lists use the following formula
>> in the member list:-
>>
>> =SUMPRODUCT(('[Master list.xls]Query'!$A$1:$A$1039=A3)*('[Master
>> list.xls]Query'!$B$1:$B$1039=B3)*('[Master list.xls]Query'!$C$1:$C$1039=C3))
>>
>> Note: Formula result => 1 means member exist in the master list.
>> Attached workbook is also attached herewith
>>
>> Best Regards,
>> --
>> DILIP KUMAR PANDEY
>> MBA-HR,B COM(Hons.),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 110062
>>
>>
>> On 12/25/09, sca...@aol.com <sca...@aol.com> wrote:
>>
>>
>> Ok, here's 2 example lists.
>>
>> Master list is the list of all the possible names and dob's.
>>
>> Member list is a list of people in a group that I am trying to check
>> to see if they exist in the Master list.
>>
>> There are a ton of columns in addition to these on the real lists, but
>> these are the only ones fields need to check for duplicates. Sorting
>> and scrolling through looking for dups gets tedious after a few
>> thousand lines...
>>
>> Thanks for your help...
>>
>> Steve
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 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
