Count duplicates as one item

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Count duplicates as one item Requirement: Knowledge of Excel Array Functions File to download: None Related articles: Data Transposing I have a list of duplicate entries as shown in the left picture. There are 19 entries altogether with duplicates. For example, China in … Read more Count duplicates as one item

Using Switchboard for easy navigation

  Home Office Excel Access Word Powerpoint Outlook About Me Disclaimers Contacts Using Switchboard for easy navigation Requirement: Visual Basic Knowledge File to download: None The benefits of using a Switchboard Switchboard in Microsoft Access is a wonderful navigation tool. It’s versatile and user-friendly. Most of the users I encountered have some sort of phobia … Read more Using Switchboard for easy navigation

Excel Formulas for PPC Keyword Match Type Manipulation

I’m a firm believer in the power of one’s own resourcefulness. This is especially true in the word of online marketing. SEM managers have a natural tendency to love any tool that can help get the job done quickly and effectively. What’s even better is having the ability to roll your own tools when necessary. … Read more Excel Formulas for PPC Keyword Match Type Manipulation