Restoring original records before the export

[mifzal.mufthi]

Hi there,

I badly need help on my excel sheet. Please refer the attached. Column A has the total users and column B has the newly imported users.

I want to identify the users who were already in the list before the import. Please help me.

Thanks in advance.

[AlKey]

Here is formula

in C2

=IFERROR(VLOOKUP(A2,$B$2:$B$8319,1,0),"NOT IN DATABASE")

[mifzal.mufthi]

Here is formula

in C2

=IFERROR(VLOOKUP(A2,$B$2:$B$8319,1,0),"NOT IN DATABASE")

Thank you for your effort but it doesn't work. Because I can remember, I saw 360 or 370 email addresses before the import.

I want to get only those email addresses. Is that possible.

[mifzal.mufthi]

Hello

Do you mean that you want to compare the 2 lists and find the common values?

If yes a title like "Compare 2 lists and find the commens" will be ok. Or elsefind a correct title and then anyone will be able to helps you.

I think you are right. Can we do that and see please? Will MATCH, LOOKUP, VLOOKUP command?

[mifzal.mufthi]

My issue is still unresolved. Will somebody help me please?

[mifzal.mufthi]

Title changed. Please help me.

[mifzal.mufthi]

Ok. ...Last try before i close this thread....

You have to change the thread title in your first post.

Go>>Edit Post>>>Go Advanced and change your title.

I am extremely sorry for the inconvenience caused. Now it is done

[Fotis1991]

Just as an idea,

In C2 and copy down

Please Login or Register  to view this content.

Hide if you like this column.

In D2 and copy down use this ARRAY formula.

Please Login or Register  to view this content.

-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.

[mifzal.mufthi]

Just as an idea,

In C2 and copy down

Please Login or Register  to view this content.

Hide if you like this column.

In D2 and copy down use this ARRAY formula.

Please Login or Register  to view this content.

-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.

Thank you but it doesn't work.

[Xx7]

Give this a try in Cell C2


=IF(ISTEXT(VLOOKUP(B2,A:A,1,0)),"Old User","New")

[mifzal.mufthi]

Give this a try in Cell C2


=IF(ISTEXT(VLOOKUP(B2,A:A,1,0)),"Old User","New")

I appreciate it but it no response. This is what I am looking for. I had a mailing list which had a subscriber base of 377. Then today, instead of creating a new mailing list, I uploaded a new subscriber base in which the total subscribers became 8642. All what I need is to get that 377 records back.

This is another clue to identify. Please see column A has a total record of 8642 and B has 8318. A-B = 324.

I want to find out the 324 email addresses. Hope it is clear to my friends.

[Xx7]

I get 434 total old database items that AREN'T in Newly Imported