All solutions How to UseMATCH Expert Solution – How to Use MATCH Function

Excel - How to Use MATCH Function - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

i want two rows to match identical data in each row and can contain duplicate values how to use this?
Solved by G. B. in 14 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 30/11/2017 - 09:06
Hi, how are you?
User 30/11/2017 - 09:06
can you solve this one?
Excelchat Expert 30/11/2017 - 09:07
Could you please show what you exactly want, it would help me better
User 30/11/2017 - 09:07
I want to filter both of this column to maximum matches possible
User 30/11/2017 - 09:07
i want to match and reconcile this
User 30/11/2017 - 09:08
can you do this?
Excelchat Expert 30/11/2017 - 09:08
Alright, do you want to filter on the basis of maximum number i.e. maximum to minimum
User 30/11/2017 - 09:08
nope
User 30/11/2017 - 09:09
do you really understood my problem
User 30/11/2017 - 09:09
i want to match them
Excelchat Expert 30/11/2017 - 09:09
Ok, let me do it for you
User 30/11/2017 - 09:09
ok
Excelchat Expert 30/11/2017 - 09:10
See the outcome in column D, the value True is matching value an dfalse as unmatching
User 30/11/2017 - 09:10
what about 25000?
Excelchat Expert 30/11/2017 - 09:10
false8
User 30/11/2017 - 09:10
it is in both the columns?
User 30/11/2017 - 09:10
so it should be matched
Excelchat Expert 30/11/2017 - 09:10
well formula runs adjacently against each other
User 30/11/2017 - 09:10
2500 should also be matched
Excelchat Expert 30/11/2017 - 09:11
Are you talking about B4&C4?
User 30/11/2017 - 09:11
one of my mate have done this
User 30/11/2017 - 09:11
man i want to reconcile entries it can be anywhere
Excelchat Expert 30/11/2017 - 09:12
Could you please show me what he exactly did and you want?
User 30/11/2017 - 09:14
this
User 30/11/2017 - 09:14
I think you cant solve it
User 30/11/2017 - 09:14
please mark it as unsolved
User 30/11/2017 - 09:15
one should not bid if they don't understand
User 30/11/2017 - 09:17
I don't want to pay for this session
User 30/11/2017 - 09:17
how can I do that
Excelchat Expert 30/11/2017 - 09:18
[Uploaded an Excel file]
Excelchat Expert 30/11/2017 - 09:18
See the excel sheet, it's done
Excelchat Expert 30/11/2017 - 09:18
Google spreadsheet has its own limitation but excel is fast and flexible, I've done as per your requirement
Excelchat Expert 30/11/2017 - 09:18
[Uploaded an Excel file]
User 30/11/2017 - 09:19
its not done
User 30/11/2017 - 09:19
see there
Excelchat Expert 30/11/2017 - 09:19
where?
User 30/11/2017 - 09:19
if 2500 is once in column a
User 30/11/2017 - 09:19
and twice in column 2
User 30/11/2017 - 09:19
then also its marking them all
User 30/11/2017 - 09:20
it shoul mark it once only
Excelchat Expert 30/11/2017 - 09:20
There is no way like you are saying
User 30/11/2017 - 09:20
there is a way
User 30/11/2017 - 09:20
in that situation

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc