Question description:
This user has given permission to use the problem statement for this
blog.
i am trying to compare column a to b in a spreadsheet
Solved by T. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
08/05/2018 - 02:56
Hello, I understand that you want to compare 2 columns. Can you elaborate on your request please?
User
08/05/2018 - 02:56
I have a list of numbers in column a and need to compare them to a similar list in column b to see which ones match
Excelchat Expert
08/05/2018 - 02:57
I see. Are you able to share that list so I can provide an accurate formula?
User
08/05/2018 - 02:57
yes
Excelchat Expert
08/05/2018 - 02:57
If not, we can just create a dummy list.
Excelchat Expert
08/05/2018 - 02:57
Okay, please upload your file or you can just copy the list using the document preview to the right.
User
08/05/2018 - 02:58
finished
Excelchat Expert
08/05/2018 - 02:58
Okay, so do you like to compare A to B or would it be B to A?
User
08/05/2018 - 02:58
a to b
Excelchat Expert
08/05/2018 - 02:59
Alright, before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question.
Excelchat Expert
08/05/2018 - 02:59
In column C I'll be writing a formula that checks if the value in column A is i column B.
Excelchat Expert
08/05/2018 - 02:59
So here, you can see the result has a mix of numbers and #N/A
Excelchat Expert
08/05/2018 - 03:00
An #N/A means that the value in column A is NOT in column B.
Excelchat Expert
08/05/2018 - 03:00
While a number means that the value in column A was found in that row in column B.
Excelchat Expert
08/05/2018 - 03:00
For instance, D000054226 (A1)
Excelchat Expert
08/05/2018 - 03:00
The formula results in 116.
Excelchat Expert
08/05/2018 - 03:00
This means that D000054226 was found in row 116 in column B.
User
08/05/2018 - 03:00
ok but I did not see the formula used
Excelchat Expert
08/05/2018 - 03:01
While D000054705 results to #N/A
Excelchat Expert
08/05/2018 - 03:01
Which means it is not in column B.
Excelchat Expert
08/05/2018 - 03:01
=match(A1,B:B,0)
Excelchat Expert
08/05/2018 - 03:01
To see the formula you can just click the cell.
Excelchat Expert
08/05/2018 - 03:01
Click Cell C1 and you will see the formula.
User
08/05/2018 - 03:01
ok
Excelchat Expert
08/05/2018 - 03:02
Got it?
User
08/05/2018 - 03:02
yes
Excelchat Expert
08/05/2018 - 03:02
Would there be anything else that I can help you with regards to the original question?
User
08/05/2018 - 03:02
that's all thanks
Excelchat Expert
08/05/2018 - 03:03
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert
08/05/2018 - 03:03
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
Excelchat Expert
08/05/2018 - 03:03
Thank you for contacting Got It Pro. Have an awesome day!
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.