Remove Duplicates in Excel 2003
In Excel 2003, if there are duplicate items in a list, you can delete them by using an Advanced Filter.
To remove the duplicates, follow the steps in this short Excel video tutorial.
______________
Similar Posts
Excel Conditional Formatting Basics
To highlight cells with a value that is too high or too low, you can use Excel Conditional Formatting. This short video shows you the steps. For detailed instructions see Excel Conditional Formatting Basics. ________________
Are You Proficient in Excel Like Bryan?
On TikTok, I follow Bryan Nothling aka thebnoth, because he’s funny, and he’s Canadian! His “working from home” videos have brightened my days, and he has over 200K followers, so I’m not the only person who enjoys them.
Video – How to Make a Simple IF Formula in Excel
Use the Excel IF function when you want to test something. The IF formula will show one result if the test result is True, and a different result if the test result is False. For example: Check if cell D7 is empty. If it is, the result is an empty string. If not, multiply C7…
Excel Humour 2022-01-10 Excel Chart Superhero
Sometimes it’s easy to make an Excel chart, and sometimes a struggle. There are days when you feel like a superhero, if you just manage to build a simple chart, and change the colours in it! Here are a couple of short videos that show how to work with Excel pie charts, and win the…
Stop GetPivotData Formula When Linking to Pivot Table
When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference. To turn this feature off, follow the instructions in this short video. For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables. ________________
Excel YouTube Channel: MrExcel by Bill Jelen
Bill Jelen is the the king of all Excel media! In addition to his MrExcel website, and his book publishing empire, and his Excel podcasts, Bill has been on YouTube since July 23, 2006 – almost 15 years ago! Let’s take a look at it.