As with most things in Excel, there are many ways to extract a list of unique or distinct values from a column of data. We’ll look at the options, and the pros and cons of each. Download the Workbook Enter your email address below to download the sample workbook. Get Workbook By submitting your email […]

Sometimes we want to find and remove duplicates in Excel, other times we just want to identify or highlight duplicates. There are loads of ways to tackle this in Excel, so let’s look at the options. Download the Workbook The workbook contains screenshots and notes so you can use it as a reference guide later, […]

Microsoft recently announced a project called Script Lab, previously known as ‘Add-In Playground’, which aims to help you learn how to write add-ins for Office. Script Lab is actually an add-in itself and runs in Excel, Word or PowerPoint and can be installed from the Office Store. Script Lab will run in Excel, Word, or […]

Excel Themes are a bundle of default colors, font styles and Shape effects. There are lots of built in Excel Themes available from the Page Layout menu: Hovering over a theme will give you a preview of the effect on your workbook. You’ll notice that different fonts will have an impact on your workbook layout. […]

Inserting, copying, moving, or cutting and pasting rows and columns is something we do every day in Excel. And there are loads of ways we can perform these repetitive tasks. Inserting Rows, Columns and Cells We can use the icons in the Insert menu on the Home tab: Or even the keyboard shortcut: Ctrl+Shift+= (or […]

In this tutorial we’re going to look at how we can use Excel Conditional Formatting to highlight rows in a table where a field matches any item in a list. Let’s look at an example, below is our table of data: And we want to highlight the rows that contain any of the categories in […]

I’ve put together this Excel custom number format guide as a resource for our members. There are loads of ways to apply custom number formats and as a result I find myself answering questions that are covered in this post on a daily basis. To be clear, number formatting in Excel is used to specify […]

Using Excel Conditional Formatting to highlight matches is easy when you team it up with a data validation list like this: Download the Excel File Enter your email address below to download the sample workbook. Get Workbook By submitting your email address you agree that we can email you our Excel newsletter. Please enter a […]

By Harold Graycar XL Numerics Developer of Excel for Customer Service Professionals The previous post on this topic included a method for finding the cell address for the maximum or minimum number in a table. Thanks for the correspondence  —  and especially that from Hervé, Saskia and Trevor for the questions about what happens if […]

By Harold Graycar XL Numerics Developer of Excel for Customer Service Professionals When dealing with large tables containing ‘buckets’ of numbers, we often need to find the location of the largest number, the smallest number, etc. There are a couple of techniques in Excel for doing this: By eye: using conditional formatting etc. By formula: using […]