|
|
|
|
#1
04-18-2024, 05:16 AM
|
|||
|
|||
this solution works. but has a problem even if B6 C6 is empty it says true. And if C6 is partially matches it says true. like $K$6:$L$157 range has "13710 44"18" and TEXTJOIN("",,$B6,$C6 "13710 44"1" ("8" missing) 
|
|
|
|
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 |
Windows 10 
Office 2019
Hybrid Mode