This blog post looks at using an Excel formula to display the sheet name in cell. By finding the sheet name using an Excel formula, it ensures that if the sheet name is changed, the formula returns the new sheet tab name.

This tutorial covers two Excel formula examples. Firstly, using the CELL, MID and FIND functions. And then using the TEXTAFTER function with CELL.

Let’s begin by looking at the CELL function.

VLOOKUP is an awesome Excel function. One of its limitations is that it can only return the first match from a list. In this tutorial, we will see how to use VLOOKUP for the last match in Excel.

VLOOKUP is typically used to look for a unique value. But what about when the value you are looking for appears multiple times in the list, and you want to return the last match.

Sure we could sort the list so that the last match would become the first, but this is not always an option.

This tutorial uses VLOOKUP for the last match. The formula used can be adapted to find the 2^nd or 3^rd match, if required.

If you are responsible for analysing a list of URL’s in Excel, then you may need to extract the domain from each URL. After extracting the domain you can perform useful reporting tasks such as grouping the domains, or counting the number of unique domains in the list.

This can be quite a difficult task especially if the URL’s are not consistent. In this article we explore a few different approaches to extract the domain from a URL. The method you choose will depend on the appearance of the URL’s in the list and the format you would like to extract the domain in.

This article covers;

1. Extract the domain including the URL protocol.
2. Extract the domain ignoring URL protocol.
3. Extract the domain without the www.
4. Extract root URL’s that don’t end with a slash (/).
5. Using helper columns to break up complex formulae.

In this blog post, we look at how to pick a name at random from a list. There are many reasons you may need this kind of random selection from a list.

It may be a neat way of deciding who is next to do the washing up, or to make a cup of tea :). Or it is useful for randomly drawing teams for a knockout cup competition.

To perform this random selection, we are going to use two different functions together. They are INDEX and RANDBETWEEN.

The Excel TEXT function is used to convert a numeric value to text in a specified number format. This function is really useful when concatenating strings that will contain a numeric value.

Excel TEXT Function Anatomy

The TEXT function in Excel requires two arguments – the text that needs formatting, and the format you want to use.

=TEXT(value, format_text)

It is very useful for displaying numbers that are used in text strings still in their number format. Examples of this include when using summary text on reports or in chart labels such as “Total sales this quarter: £4,073”.