Question description:
This user has given permission to use the problem statement for this
blog.
please read full then only answer
i need to match maximum possible amount from 2 rows
where amount can be identical and repeat many times
I want to reconcile this and do not mark amounts if it remains unmatched
remember there are repeated amounts in same column
Solved by G. S. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/12/2017 - 11:31
Hello welcome to excel chat
Excelchat Expert
05/12/2017 - 11:32
i have seen your requirement
Excelchat Expert
05/12/2017 - 11:32
i think you want to match 2 columns with identical data to maximum possible extent to reduce the manual work right?
User
05/12/2017 - 11:32
hello
User
05/12/2017 - 11:32
yeah
Excelchat Expert
05/12/2017 - 11:33
ok
Excelchat Expert
05/12/2017 - 11:33
this can be done using conditional formatting method in excel
User
05/12/2017 - 11:33
ok
Excelchat Expert
05/12/2017 - 11:33
for conditional formating i will have to do this work loaclly
Excelchat Expert
05/12/2017 - 11:33
on my computer
User
05/12/2017 - 11:33
ok
Excelchat Expert
05/12/2017 - 11:34
do you have any file to do this?
User
05/12/2017 - 11:34
currently I don't have a file
Excelchat Expert
05/12/2017 - 11:34
ok i will create a dummy data for you and send you a sheet
Excelchat Expert
05/12/2017 - 11:34
please wait
User
05/12/2017 - 11:34
ok
Excelchat Expert
05/12/2017 - 11:34
i am working on it locally
Excelchat Expert
05/12/2017 - 11:35
but note that it will not match repeated values if one is 5 times and the other is 6 times in a column
Excelchat Expert
05/12/2017 - 11:36
it will be matched if a amount is repeating for same count of no in both the columns
Excelchat Expert
05/12/2017 - 11:36
then it will be matched
User
05/12/2017 - 11:36
ok
User
05/12/2017 - 11:36
I understand
Excelchat Expert
05/12/2017 - 11:36
please wait
Excelchat Expert
05/12/2017 - 11:39
hello
User
05/12/2017 - 11:39
hey
Excelchat Expert
05/12/2017 - 11:39
here is the file you wanted
[Uploaded an Excel file]
User
05/12/2017 - 11:39
ok let me check it
Excelchat Expert
05/12/2017 - 11:40
sure
Excelchat Expert
05/12/2017 - 11:42
this formula is counting no of Occurrence of each amount in both the coulns
Excelchat Expert
05/12/2017 - 11:42
and if diff of both is =0 then it will be matched
User
05/12/2017 - 11:42
yeah its working awesome
User
05/12/2017 - 11:43
thank you
User
05/12/2017 - 11:43
it was not possible for me without you.
Excelchat Expert
05/12/2017 - 11:43
sure
Excelchat Expert
05/12/2017 - 11:43
thank you for choosing excelchat
Excelchat Expert
05/12/2017 - 11:43
please provide your valuable feedback
Excelchat Expert
05/12/2017 - 11:44
please end this session from your end if you dont have any further query regarding this matter
User
05/12/2017 - 11:44
ok sure
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.
