Question description:
This user has given permission to use the problem statement for this
blog.
Using the data in Column A I want to match the data in Column B showing me what data is missing or unmatched. How can I do this?
Solved by V. L. in 59 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/02/2018 - 01:58
Hello, Welcome to Got It Pro
Excelchat Expert
02/02/2018 - 01:58
May I have a look at your file please
Excelchat Expert
02/02/2018 - 02:01
Are you there?
User
02/02/2018 - 02:01
yes
Excelchat Expert
02/02/2018 - 02:02
Okay great. So you want to match A and B columns to tell which are matching and which are not?
User
02/02/2018 - 02:03
correct
Excelchat Expert
02/02/2018 - 02:03
and it should display "matched or not matched"?
User
02/02/2018 - 02:04
yes
User
02/02/2018 - 02:04
matched
Excelchat Expert
02/02/2018 - 02:04
Okay. Please give me two minutes
User
02/02/2018 - 02:05
can you get them side by side
User
02/02/2018 - 02:06
234567 is matched
User
02/02/2018 - 02:08
123456 is not matched
Excelchat Expert
02/02/2018 - 02:08
By side by side you mean?
User
02/02/2018 - 02:08
yes
User
02/02/2018 - 02:09
cellb1 should be blank and the others side by side
User
02/02/2018 - 02:09
Cell B1
Excelchat Expert
02/02/2018 - 02:10
cell B1 has the number 987654
User
02/02/2018 - 02:11
It does not match A1
User
02/02/2018 - 02:11
I would like column B unscrambled to match column A side by side
User
02/02/2018 - 02:13
Automatically sort the data in column B to match Column A
Excelchat Expert
02/02/2018 - 02:14
we have to manually sort the data first then
Excelchat Expert
02/02/2018 - 02:16
Please check now
User
02/02/2018 - 02:17
some match, sme dont
Excelchat Expert
02/02/2018 - 02:17
so you want to display them so they match with c olumn A ?
User
02/02/2018 - 02:18
yes
Excelchat Expert
02/02/2018 - 02:19
Okay
User
02/02/2018 - 02:22
are u with me?
Excelchat Expert
02/02/2018 - 02:23
Yes I am here
Excelchat Expert
02/02/2018 - 02:23
I am working on your file.
User
02/02/2018 - 02:23
ty
Excelchat Expert
02/02/2018 - 02:26
No problem. Just give me few minutes
Excelchat Expert
02/02/2018 - 02:33
Its is very difficult to do with formula, Its a VBA query
User
02/02/2018 - 02:33
VBA query ?
Excelchat Expert
02/02/2018 - 02:33
like by coding.
User
02/02/2018 - 02:34
can we talk by phone?
Excelchat Expert
02/02/2018 - 02:35
No I am sorry, We dont have that facility
Excelchat Expert
02/02/2018 - 02:43
please check.
User
02/02/2018 - 02:43
you did it! how?
Excelchat Expert
02/02/2018 - 02:44
by sorting the columns in ascending order
User
02/02/2018 - 02:45
show me?
User
02/02/2018 - 02:51
please show me...I have to go
Excelchat Expert
02/02/2018 - 02:51
I have used VLOOKUP to match and sort your data
Excelchat Expert
02/02/2018 - 02:51
=VLOOKUP(A1,$B$1:$C$8,1,FALSE)
Excelchat Expert
02/02/2018 - 02:51
Add this to column C and you will get your results
Excelchat Expert
02/02/2018 - 02:53
It is showing the matching columns for A
User
02/02/2018 - 02:54
Thank you!
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.