Question description:
This user has given permission to use the problem statement for this
blog.
I need to find values in G1 to G30(30 values) in H1 to H100(100 values). if within 100 ,the given 30 matches.
Solved by G. H. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
23/05/2018 - 12:29
Hello, how are you?
User
23/05/2018 - 12:30
hi
User
23/05/2018 - 12:30
hi
User
23/05/2018 - 12:31
how to check if values given in E are there in values given in C
Excelchat Expert
23/05/2018 - 12:31
I have read through your query, o you mind uploading the excel file so that I can examine it locally?
User
23/05/2018 - 12:31
i have just copies the data u need on right
User
23/05/2018 - 12:31
copied*
User
23/05/2018 - 12:32
?? anyone there?
Excelchat Expert
23/05/2018 - 12:32
Yes I am here
User
23/05/2018 - 12:33
u got my question?
Excelchat Expert
23/05/2018 - 12:33
Trying to figure it out
User
23/05/2018 - 12:33
ok
User
23/05/2018 - 12:34
can all values be checked alltogether or i have to do it one at a time
Excelchat Expert
23/05/2018 - 12:34
What should be the expected output and where should it be?
Excelchat Expert
23/05/2018 - 12:34
They can be checked
User
23/05/2018 - 12:35
if there is any value which matches should be given in a separate cpolumn
Excelchat Expert
23/05/2018 - 12:35
So you just want to confirm if the values match, am assuming that
User
23/05/2018 - 12:36
if there is any value which is in column E and also in column C . it shud be highlighted of taken out
Excelchat Expert
23/05/2018 - 12:38
Okay, please check if that makes sense
[Uploaded an Excel file]
Excelchat Expert
23/05/2018 - 12:39
Are you there?
User
23/05/2018 - 12:39
perfect. got it
User
23/05/2018 - 12:39
thanks
Excelchat Expert
23/05/2018 - 12:39
You are so welcome. Please remember to rate me well after closing the session. A 5star will be kind enough. And a nice comment if you don’t mind.
User
23/05/2018 - 12:40
wait
Excelchat Expert
23/05/2018 - 12:40
Am waiting
Excelchat Expert
23/05/2018 - 12:40
Any trouble?
User
23/05/2018 - 12:40
na.... got it ..
User
23/05/2018 - 12:40
thanks alot man
User
23/05/2018 - 12:40
how to rate?
Excelchat Expert
23/05/2018 - 12:41
cool, you will see the option to rate after closing the session
User
23/05/2018 - 12:41
alryt
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.