# Category: 30XL30D

## 30 Excel Functions in 30 Days: 20 – ADDRESS

Yesterday, in the 30XL30D challenge, we found items in an array with the MATCH function, and learned that it plays nicely with other functions, like VLOOKUP and INDEX. For day 20 in the challenge,...

## 30 Excel Functions in 30 Days: 19 – MATCH

Yesterday, in the 30XL30D challenge, we found text strings with the SEARCH function, and used IFERROR and ISNUMBER to deal with its error results. For day 19 in the challenge, we’ll examine the MATCH...

## 30 Excel Functions in 30 Days: 18 – SEARCH

Yesterday, in the 30XL30D challenge, we identified errors with the ERROR.TYPE function, and saw that it could help with Excel troubleshooting. For day 18 in the challenge, we’ll examine the SEARCH function. It looks...

## 30 Excel Functions in 30 Days: 17 – ERROR.TYPE

Yesterday, in the 30XL30D challenge, we found values with the LOOKUP function, and we’ll use that function again today, when working with error results. For day 17 in the challenge, we’ll examine the ERROR.TYPE...

## 30 Excel Functions in 30 Days: 16 – LOOKUP

Yesterday, in the 30XL30D challenge, we had some fun with the REPT function, and created in-cell charts and a tally sheet. Now it’s Monday, and time to put those thinking caps back on! For...

## 30 Excel Functions in 30 Days: 15 – REPT

Yesterday, in the 30XL30D challenge, we took things easy, with the T function. It checks a value to see if it’s text, and other functions do that too. For day 15 in the challenge,...

## 30 Excel Functions in 30 Days: 14 – T

Welcome to another weekend in the 30XL30D challenge, and you’re probably exhausted from a long week of Excel work, and yesterday’s complicated example for the TRANPOSE function. Saturday is the perfect time for a...

## 30 Excel Functions in 30 Days: 13 – TRANSPOSE

Yesterday, in the 30XL30D challenge, we counted columns with the COLUMNS function, and now it’s time for something a bit more demanding. For day 13 in the challenge, we’ll examine the TRANSPOSE function. With...

## 30 Excel Functions in 30 Days: 12 – COLUMNS

Yesterday, in the 30XL30D challenge, we got cell details with the CELL function, and learned that it’s useful for a few things, like extracting a worksheet name. For day 12 in the challenge, we’ll...

## 30 Excel Functions in 30 Days: 11 – CELL

In Day 4 of the 30XL30D challenge, we got details about the operating environment, with the INFO function — things like the Excel version and recalculation mode. For day 11 in the challenge, we’ll...

## 30 Excel Functions in 30 Days: 10 – HLOOKUP

For day 10 in the 30XL30D challenge, we’ll examine the HLOOKUP function. Not too surprisingly, this function is very similar to VLOOKUP, and works with items that are in a Horizontal list. Poor HLOOKUP...

## 30 Excel Functions in 30 Days: 09 – VLOOKUP

For day 9 in the 30XL30D challenge, we’ll examine the VLOOKUP function. As you can guess by its name, this is one of the Lookup functions, and works with items that are in a...