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