Microsoft Office Forums - View Single Post - [Solved] Highlight with Maching function as Pair

Thread: [Solved] Highlight with Maching function as Pair

View Single Post

Old

04-18-2024, 05:16 AM

stricky

stricky is offline

stricky uses Windows 10

Windows 10 stricky uses Office 2019

stricky uses Office 2019

Office 2019

Novice

The original poster

Join Date: Jun 2023

Location: Bangladesh

Posts: 25

stricky is on a distinguished road

Default

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)

Reply With Quote