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.