Solutions

2 Methods to Find the Largest or Smallest N Items in Your Excel Worksheet

Sometimes you need to find the largest N items or the smallest N items in a range in your worksheet. Here we will provide two effective methods for you. Finding the largest N items or the smallest N items in a range is a very ordinary task in your work. In our previous article How to Highlight the Top or Bottom N Items by Conditional Formatting in Excel, we have introduced the methods of using conditional formatting. And in the following part, we will discuss about the two other methods in...

Read more »

6 Useful Tips for Bulleted or Numbered Lists in Your Word Document

In today’s article, there are 6 useful tips available to help you make easy use of numbered or bulleted lists in your Word document. “Bullets” and “Numbering” are 2 useful features in Word, ensuring items in your Word document are organized in a neat way. However, as long as we continue benefiting from this function, there are little problems which can be annoying and ruin our document formatting sometimes. Therefore, here are 6 tips which make it easier to handle bulleted or...

Read more »

How to Auto Save Specific Email Attachments with Outlook VBA

Many users hope that Outlook can auto look for specific words in the attachment names and then save the specific attachments to a local folder on their computers. This article will teach you how to accomplish it with Outlook VBA. In my daily works, if the attachments in received emails are not very important, I prefer not to save them to my local disk, just read them in Outlook directly. But if the attachments are important, such as personnel regulations, monthly working report, I will save...

Read more »