Quote:
Originally Posted by Purfleet
I think a left with an index and match could work
can you mock up an example so we can test it?
|
Here is the mock up, but I ran into another issue.
- The third sheet "Cross match" must display the "Common Codes" listed in the first sheet. And these codes aren't always the same of course.
- The third sheet must highlight in some way the unlisted items in either sheet.
The only thing making this difficult are missing/added items in either sheet. You will notice an item on each sheet that is unlisted in the other.
10-26-2020, 04:38 AM
Similar Threads
Searching for any instances of immediate word repetition (eg "the the")
Windows 7 64bit 
Office 2016
Threaded Mode