**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have 10k unique codes that I need i need to see if they are in a list of 60k.
I cant have duplicates thats why I am doing this

Solved by A. B. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
18/12/2017 - 08:10

Hello

User
18/12/2017 - 08:10

hyi

User
18/12/2017 - 08:10

hi*

Excelchat Expert
18/12/2017 - 08:11

your spreadsheet is emptu

Excelchat Expert
18/12/2017 - 08:11

empty*

User
18/12/2017 - 08:11

yes I know

User
18/12/2017 - 08:11

i need to know if there is an easy way to search for a list of codes in a bigger list

Excelchat Expert
18/12/2017 - 08:12

Yes there is a way.

User
18/12/2017 - 08:13

i have 5k "codes" labed friend3233 for example

User
18/12/2017 - 08:13

i need to make 50k more of those codes but i cant have the 5k already made in that list

Excelchat Expert
18/12/2017 - 08:15

Can you give example at the view.

Excelchat Expert
18/12/2017 - 08:17

Still there.

User
18/12/2017 - 08:17

hi sorry computer froze

Excelchat Expert
18/12/2017 - 08:18

ok

Excelchat Expert
18/12/2017 - 08:18

Ol

User
18/12/2017 - 08:18

these are the codes I have right now

User
18/12/2017 - 08:19

I need to make 50k more that look just like this but I have to take out the 5k here that are already made

Excelchat Expert
18/12/2017 - 08:20

You mean you don't have the 50k codes.

User
18/12/2017 - 08:20

yeah

User
18/12/2017 - 08:20

i have yet to create them

User
18/12/2017 - 08:20

when I do create them how do i take out this 5k

User
18/12/2017 - 08:21

it will take me 5 mins to create the 50k i just dont know how too take out the 5k i already have made

Excelchat Expert
18/12/2017 - 08:21

Ok.

Excelchat Expert
18/12/2017 - 08:21

Suppose that you need to make the new codes at the col D

User
18/12/2017 - 08:23

?

User
18/12/2017 - 08:23

ah okay

Excelchat Expert
18/12/2017 - 08:24

NOw

User
18/12/2017 - 08:24

you want me to make them now?

Excelchat Expert
18/12/2017 - 08:26

if you type code at column D and the cell at col C have value more than 0 then the code is in the 5K list

Excelchat Expert
18/12/2017 - 08:27

And if the cell at column C has the value 0 then the code is not at the 5k codes.

User
18/12/2017 - 08:27

then how would i delete the codes in it

Excelchat Expert
18/12/2017 - 08:29

Got it ??

User
18/12/2017 - 08:29

yeah

User
18/12/2017 - 08:29

but how do I delete them all when im done

Excelchat Expert
18/12/2017 - 08:30

So as an example the code at cell D1 is in the list at col A so cell C1 shows 1

User
18/12/2017 - 08:31

yes

User
18/12/2017 - 08:31

do i have to individually delete them

Excelchat Expert
18/12/2017 - 08:31

Otherwise the code at D2 is not at the list of codes at col A so the cell C2 is 0

Excelchat Expert
18/12/2017 - 08:31

Delete what??

User
18/12/2017 - 08:32

again I need to create a new list of 50k unique codes. The 5k right here can not be in that list

User
18/12/2017 - 08:32

once i find out what ones are in the new list of 50k codes

User
18/12/2017 - 08:33

how do i delete them from the new list

Excelchat Expert
18/12/2017 - 08:34

You have to filter them according to the values at column C.

Excelchat Expert
18/12/2017 - 08:34

Filter the cells that have the values not equal 0.

Excelchat Expert
18/12/2017 - 08:35

And then delete them all.

User
18/12/2017 - 08:36

so if i delete the cells in C they will delete from the list ?

Excelchat Expert
18/12/2017 - 08:38

As an example suppose that the list at column D is the new 50K

Excelchat Expert
18/12/2017 - 08:38

Ok

Excelchat Expert
18/12/2017 - 08:38

There are some new codes and some codes is at the 5K list.

User
18/12/2017 - 08:38

i have the list of the new codes

Excelchat Expert
18/12/2017 - 08:39

So you need to delete that codes from the 50k list

User
18/12/2017 - 08:39

yeah

User
18/12/2017 - 08:41

those are the new codes

User
18/12/2017 - 08:43

are you still there

Excelchat Expert
18/12/2017 - 08:47

yes

Excelchat Expert
18/12/2017 - 08:47

Sorry about the delay

User
18/12/2017 - 08:48

its okay

User
18/12/2017 - 08:48

there shouldnt be a space in the codes

Excelchat Expert
18/12/2017 - 08:48

So your new list is at col G

User
18/12/2017 - 08:48

how do i get rid of that

User
18/12/2017 - 08:48

yes but the space shouldnt be inbetween the, \

User
18/12/2017 - 08:49

how do I remove the spce between the numbers and letters

Excelchat Expert
18/12/2017 - 08:50

Use the formula subtitle.

User
18/12/2017 - 08:50

on all of them?

Excelchat Expert
18/12/2017 - 08:50

Like at the column H

User
18/12/2017 - 08:52

perfect thank you

Excelchat Expert
18/12/2017 - 08:53

Now I'll make the formula at column I to check if the code at col H is at the 5k list or not.

User
18/12/2017 - 08:54

oops my bad

User
18/12/2017 - 08:54

if i where to put the new numbers in col a and the old in col b and then do "remove duplicates" would that work

Excelchat Expert
18/12/2017 - 08:59

No

Excelchat Expert
18/12/2017 - 08:59

You have to add them at the same column.

Excelchat Expert
18/12/2017 - 09:00

I mean you have to add the 5k below the 50K list and then remove educated.

User
18/12/2017 - 09:01

how do i add them below

Excelchat Expert
18/12/2017 - 09:02

Copy all the 5k cells and paste them at the last cell of the new 50k list.

User
18/12/2017 - 09:02

i tried and it tells me i cant

Excelchat Expert
18/12/2017 - 09:03

If you need I can make this for you at excel and attach the file for you.

User
18/12/2017 - 09:03

yeah can you add the 5k below so i can filter them out

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*