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
