A Tricky Excel task

Good old Will is doing a free Excel Ninja webinar soon. Useful to many I am sure.

Here’s my challenge of the day. I have five worksheets in an Excel document. Each sheet contains a list of at LEAST 1000 cells, and each cell contains ascii.

I need a list of duplicate cells in worksheets 2-5 which do NOT appear in worksheet 1.

Can anyone tell me how to do that please? Will – if you do it in the seminar, I’ll do my damnedest to send someone onto the webinar.

Leave a Reply

Your email address will not be published. Required fields are marked *