+ Reply to Thread
Results 1 to 5 of 5

How to find unique records from multiple sheets

  1. #1
    Registered User
    Join Date
    05-17-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    How to find unique records from multiple sheets

    Hello,

    Can any one help me in this. I have an excel sheet which has 2 sub sheets. Each sheet has email address. I want to filter both the sheets and take out unique email from each of them and paste the information in 3 sheet.

  2. #2
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Hong Kong
    MS-Off Ver
    Office 365 PC Version
    Posts
    187

    Re: How to find unique records from multiple sheets

    Hi,

    You should be able to do this with DATA/ADVANCED/

    You will need to fill various options. Note that the results must be in the same spreadsheet.

    Easiest will be to copy all email address into a single column and then apply data/advanced unique etc.

    If you have a sample workbook i can show you more precisely.

    regards John

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: How to find unique records from multiple sheets

    Hi Mike

    An easy way would be to copy both sheets to sheet 3 (ensuring the email addresses are in the same column!), remove duplicates (included in Data Tools section of the Data tab) . Am I missing something that would prevent this working?

    Regards
    Alastair

  4. #4
    Registered User
    Join Date
    05-17-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How to find unique records from multiple sheets

    Hi Alastair

    I know that process, but I am not able to do that because there is no space available. The sheet is full and the remaining email address are on the next sheet. So I want to filter both the sheets to get unique email address. Is there a way to it please help me. Its very important

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,988

    Re: How to find unique records from multiple sheets

    1) Your telling us the file is over 2 mln row long?

    Because excel 2007 has over 1 mln rows per sheet.

    2) copy the sheet to worksheet 3 and use remove duplicated

    copy sheet 2 to worksheet 3 (or 4) and use remove duplicated

    after that copy sheet 3 and 4 and use remove duplicated.

    finished
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1