This tutorial will return non-adjacent columns with the FILTER function. Dynamic array functions such as FILTER and SORT can only return consecutive columns natively. However, there are various methods to specify the columns to return from the array. Functions such as CHOOSECOLS, CHOOSE and INDEX are wonderful for this task.
You can download the Excel workbook to follow along
This tutorial covers how to make table column references absolute. It will cover both table column and cell references.
Download the Excel workbook to follow along.
Many Excel users are familiar with lookup functions such as VLOOKUP, INDEX and MATCH to look up information in a list. But how about performing a picture lookup in Excel to return a picture dependent upon the contents of a cell.
This requires a little extra thought as a standard VLOOKUP is not capable of returning a picture from a list.
In this blog post, we will explore how to create a picture lookup. We will look at how to return the picture of a flag dependent upon the country name that is selected from a list.
Conditional Formatting is an amazing feature of Excel. It is sure to create a spark of interest and questions during training. People see the potential in their spreadsheets and how easy their team could visualise their data and create engaging reports.
This tutorial looks at the two most requested Conditional Formatting tricks asked by Excel users.
Download the file used in this video to follow along.
In this post, we look at a neat Excel VLOOKUP trick to select a column for the data to return instead of specifying a column index number.
This is one of the biggest frustrations for beginners to VLOOKUP and for users who work with wide data sets. Counting the columns to enter the correct index number is not ideal.
Well, this simple trick removes that hassle and will mean you only have to click the column now. Let’s see how to do this.
