Hello, I am looking for assistance with a formula that will compare data in Column A and if a match occurs, the formula with for those matching accounts see if the data in column O matches too and if not will return "MISMATCH" for both or if they match just return blank.mismatch.JPG
Appreciate any assistance with this.
Last edited by lilsnoop; 05-17-2023 at 11:46 AM.
Sorry meant to have this in formulas not vba. Not sure how to transfer.
1. Moved.
2. Try:
=IF(COUNTIFS(A:A,A2,O:O,O2)=COUNTIF(A:A,A2),"","Mismatch")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
If you are now using O365, you can also use this:
=MAP(A2:A12,O2:O12,LAMBDA(x,y,IF(COUNTIFS(A:A,x,O:O,y)=COUNTIF(A:A,x),"","Mismatch")))
delete ALL expected results first. If you ARE using O365, please update your profile appropriately.
Thank you Glenn! I'm still using Excel 2016 at work, but your 1st formula worked perfectly.
You're welcome. I realised that you were still using 2016 AFTER I posted V2...
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
For easy comparison: you can also use:
Formula:
Please Login or Register to view this content.
to bring the data from Column O with any matches from Column A
Kirkules... not with Excel 2016!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks