2:38
This Micro Tutorial explains how to quickly distill a column of data down to a reduplicated list of unique values, also if the duplicated cells are completely blanks.
Suggested Videos
The colour setting for coding in the VB editor (VBE) of Microsoft Office is a left-over from a past century. Here is how - with a few steps - to bring new life to the ancient editor.
- Microsoft Office
- Outlook
- Microsoft Access
- VBA
- Editors IDEs
- Microsoft Excel, Microsoft Word
When adding new VBA features to a workbook, some parts may be difficult but you struggle through it because it's important to you or to someone you're helping. During that struggle you may say to yourself that "I wish I could find an easier way". Ho…
Suggested Courses
Next Video:Using the new Analyze Data button in Excel