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.
______________
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.
______________
An Excel worksheet might have headings in column A, and subheadings in column B, with blank cells under each heading. If you want to sort or filter that data, you’ll need to fill in the blank cells. This short video shows you a quick way to clean up the data. For written instructions please read…
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.
Do you ever use check boxes on your Excel worksheets? They’re handy for choosing options, or marking completed items in a To Do list.
You can quickly change values in Excel, without using formulas. Follow the steps in this short video to add, subtract, multiply or divide, by a specific amount or percentage. For detailed instructions, please visit Excel data entry tips. ______________
Sometimes a VLOOKUP formula returns an #N/A error, even though you can see the value you’re looking for in the lookup table. The most common cause for this is a text “number” in one place, and a real number in the other place. See how you can fix that VLOOKUP problem.
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. ________________