**Question description:**

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

Is this working? I'm trying to see if I can chat with someone live without paying. Thanks.

Solved by O. L. in 20 mins

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

User
14/06/2018 - 03:36

Hi

Excelchat Expert
14/06/2018 - 03:36

Hi

Excelchat Expert
14/06/2018 - 03:36

Welcome to Got it Pro

User
14/06/2018 - 03:36

Here's what I'm trying to do and would love your input

User
14/06/2018 - 03:36

Give me one second to write something in the spreadsheet

Excelchat Expert
14/06/2018 - 03:36

Yes please tell

Excelchat Expert
14/06/2018 - 03:36

ok

User
14/06/2018 - 03:37

Actually, it's not allowing me to connect to the spreadsheet at this moment

User
14/06/2018 - 03:37

So I'll try to explain

User
14/06/2018 - 03:37

I have a spreadsheet with about 10,000 entries in column A

User
14/06/2018 - 03:37

These are all duplicates

Excelchat Expert
14/06/2018 - 03:37

ok

User
14/06/2018 - 03:38

I want to delete any duplicate values that don't contain one of three numbers in column B

Excelchat Expert
14/06/2018 - 03:38

can you share data in excel?

Excelchat Expert
14/06/2018 - 03:38

that can help better in understanding

User
14/06/2018 - 03:38

I would like to but it's not allowing me in the window

User
14/06/2018 - 03:39

Let me try to see if I can get it to work

Excelchat Expert
14/06/2018 - 03:39

ok

User
14/06/2018 - 03:39

Are you still there?

Excelchat Expert
14/06/2018 - 03:39

Yes

Excelchat Expert
14/06/2018 - 03:39

I am here

Excelchat Expert
14/06/2018 - 03:41

I can see the data

User
14/06/2018 - 03:41

Okay great

Excelchat Expert
14/06/2018 - 03:41

Tell now what is required in thsi

Excelchat Expert
14/06/2018 - 03:41

this*

User
14/06/2018 - 03:42

So what I'm trying to do is delete any name (all references to the name) if column B does not have particular numbers (say 9 or 2)

Excelchat Expert
14/06/2018 - 03:42

So you want to keep names where column B has 9 or 2?

User
14/06/2018 - 03:42

So in this example, it would leave us with Bill, Sam, and Leo

User
14/06/2018 - 03:42

But delete all references to Ted

Excelchat Expert
14/06/2018 - 03:43

You can apply filter then

Excelchat Expert
14/06/2018 - 03:43

See now

User
14/06/2018 - 03:43

Or But if I apply the filter, so for example for 9s

User
14/06/2018 - 03:43

I would lose all the other Bills

User
14/06/2018 - 03:44

I want to keep all the bills, because one of the numbes in column B is a 9

Excelchat Expert
14/06/2018 - 03:44

Yes

User
14/06/2018 - 03:44

And delete all the Sams, because None of the values in column B is a 9

User
14/06/2018 - 03:44

And do this simulatenously for several values

Excelchat Expert
14/06/2018 - 03:44

You should select bth 9 and 2

Excelchat Expert
14/06/2018 - 03:45

This will give you a list as mentioned on sheet 2

Excelchat Expert
14/06/2018 - 03:45

Have a look on sheet 2

User
14/06/2018 - 03:45

Okay

Excelchat Expert
14/06/2018 - 03:45

Do you see?

Excelchat Expert
14/06/2018 - 03:46

This will tell you which all names to keep

Excelchat Expert
14/06/2018 - 03:46

Name to Keep

User
14/06/2018 - 03:46

Okay, once I have that list of names to keep, I can than filter based on that list?

Excelchat Expert
14/06/2018 - 03:46

Then you can apply vlookup like i have applied on sheet 1

Excelchat Expert
14/06/2018 - 03:46

See column C

Excelchat Expert
14/06/2018 - 03:47

Which ever is N/A can be removed them to get the entire list

Excelchat Expert
14/06/2018 - 03:47

Do you see?

Excelchat Expert
14/06/2018 - 03:48

Let me know if that helps

Excelchat Expert
14/06/2018 - 03:48

?

Excelchat Expert
14/06/2018 - 03:48

Are you there?

Excelchat Expert
14/06/2018 - 03:50

Please let me know if you need anything else

Excelchat Expert
14/06/2018 - 03:50

Please do give good rating and reviews

Excelchat Expert
14/06/2018 - 03:50

It would help a lot

**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.*