On Friday, June 26, 2015 at 1:59:18 AM UTC-7, Claus Busch wrote:
Hi Howard,

Am Fri, 26 Jun 2015 01:37:15 -0700 (PDT) schrieb L. Howard:

Not sure how important it is to have all instances of a "no match" instead of a single one.

You cannot run for each cell in the range("A2:A16"). You have to run
only for the first occurance of a value

scenario1:
Input-1 is once in "Input" and three times in "OutPut"
With FindNext you find all 3 matches
Without you only find the first occurance

Scenario2:
Input-1 is twice in "Input" and three times in "Output"
If you run Find with FindNext for each occurance you will get 6 matches,
3 original and 3 duplicates.
If you run without FindNext you find the first occurance twice.

If another result is expected the OP should change his table layout


Regards
Claus B.


Gotcha, it shall be fine as is and I thank you again.

Howard