Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm currently using the EXACT function to compare two groups of text.
Is there a macro I can write or function I can use where Excel can tell me, no it's not an exact match and highlight or format where the text starts to not match. So it matches up until it gets to the 255th character, and maybe bolds in red at the start of non-exact-match. Please note I'm using Exact b/c the spacing, text, everything within the cell must exactly match. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need a function to return EXACT row number of a match | Excel Worksheet Functions | |||
How to get exact match with LOOKUP function? | Excel Worksheet Functions | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
Filter function - exact match... | Excel Programming | |||
MATCH function - 2 columns w/ SIMILAR, not EXACT data | Excel Worksheet Functions |