While using a Find & replace we get a message that says "Info: Find Replace (3): 5893 records were found and 14318 records were not found."
Why do not you add a Flag column say "Found & Replaced?" with "Yes" for those where it is found for 5893 records and "NO" for those 14318 records where we did not find anything.
This will help everyone I believe where data comes from multiple sources and used for consolidation