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.