A Tricky Excel task

Published by Dixon Jones on

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.

Categories: Search Engine Optimization

Dixon Jones

An award-winning Search and Internet Marketer. Search Personality of the year Lifetime achievement award Outstanding technology individual of the year International public speaker for 20 years in the field of SEO and Internet Marketing, including: Pubcon; Search Engine Strategies (SMX); Brighton SEO; Ungagged; Search Leeds; State of Search; RIMC and many more.

0 Comments

Leave a Reply

Avatar placeholder

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

Internet Marketing Presentations Search Engine Optimization

Best Search Conferences for Speakers

I have been to many conferences on search over the years. If you are - or want to be - on the speaker circuit, here's my pick of the best.

Internet Marketing Presentations

Tips on How to be a Better SEO Speaker

Let’s be clear – there are some insanely talented public speakers in the SEO Industry. But there are also some absolute disasters. If you apply to speak at a Brighton SEO or a Pubcon and Read more…

Internet Marketing Presentations

How I Built Links for InLinks

When InLinks.net; my Internal Linking Tool, was launched, it had a mountain to climb. It still has a way to go, but it’s making an impact in a competitive arena. These are the slides and Read more…