How to find unique records from multiple sheets

[Mike Nelson]

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.

[John Vieren]

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

[aydeegee]

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

[Mike Nelson]

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

[oeldere]

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