Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2024, 08:53 AM
p45cal's Avatar
p45cal p45cal is online now Highlight with Maching function as Pair Windows 10 Highlight with Maching function as Pair Office 2021
Expert
 
Join Date: Apr 2014
Posts: 873
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

A little suggestion to make things more robust. It doesn't matter with your sample data but it might matter with different data.
In columns B&C you might have:
1381 and 38"24
and in columns K & L you might have somewhere:
13813 and 8"24
When the two pairs are concatenated they both look the same:
138138"24
but they're not actually a match but the current formula would say it is a match.


That can be corrected by changing from:
Code:
=ISNUMBER(MATCH(CONCATENATE(K6,L6),CONCATENATE($B$6:$B$440,$C$6:$C$440),0))
to:
Code:
=ISNUMBER(MATCH(CONCATENATE(K6,"¬",L6),CONCATENATE($B$6:$B$440,"¬",$C$6:$C$440),0))
Now one looks like:
1381¬38"24
and the other:
13813¬8"24
so they aren't a match any more.

It doesn't have to be that ¬ character, a space would be almost as good; any character that you wouldn't expect to see in the data would be best.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Compair two pair of cells: function usage and_woox Excel 5 01-31-2023 01:12 AM
Highlight with Maching function as Pair Restrict Editing function disable insert textbox function IanM_01 Word 5 11-21-2015 02:29 AM
Highlight with Maching function as Pair Is there a function to easily and quickly highlight? Verbum Word 3 02-05-2013 10:09 AM
mapping from token to text/number pair JettyGuy Word 0 08-13-2011 10:47 AM
find - reading highlight - highlight all / highlight doesn't stick when saved bobk544 Word 3 04-15-2009 03:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft