# Excel - IF Function Problem - Expert Solution

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
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
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
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
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
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.

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.