Check if there is a match to a cell in the rest of the workbook [Solved/Closed]

Ask a question Ixon - Last answered on Apr 11, 2016 at 04:45 PM by Ambucias

I've got a workbook that has divided a list between 10 different worksheets (based upon their categorization), unfortunately, the list that was used is a bit out of date. I need to find out which of the values in the up-to-date list are missing from the rest of the workbook. Is there a formula or macro that will allow me to do this?

plus moins

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from CCM forum users to correspond showing mutual respect. Therefore, when requesting assistance, it is suggested to be courteous, as for elsewhere in similar circumstances. (i.e. please, thank you, appreciate, grateful, etc.)

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.


Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!