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.