|
#1
|
||||
|
||||
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)) Code:
=ISNUMBER(MATCH(CONCATENATE(K6,"¬",L6),CONCATENATE($B$6:$B$440,"¬",$C$6:$C$440),0)) 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. |
|
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 |
Restrict Editing function disable insert textbox function | IanM_01 | Word | 5 | 11-21-2015 02:29 AM |
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 |