Select Page

## Excel Video 372 Introducing Excel 2013

Welcome to Excel Video 372, the first video on Excel 2013! Excel 2013 has some really cool features that I think will help you a lot. As powerful as the new features are, one of the first things we’ll do is turn off animation in Office 2013. The way I’ll show you how...

## Excel Video 371 Using Arrays to See if a List is Unique

I have one more array trick in Excel Video 371 before we move on to a new topic. Today we’ll use a COUNTIF function inside a MAX function inside an IF function to determine if a list is unique. It’s really not quite as bad as that sounds. We’ll set up a COUNTIF...

## Excel Video 370 Using Arrays to See if Data is Sorted

Excel Video 370 has an array formula that tells you if your list isn’t sorted. The trick is to know that Excel treats B as being greater than A, so our array formula will catch times when A comes after B in a sorted list. Remember the AND function is true if all of...

## Excel Video 369 Using Arrays with TRUNC and Using Arrays to Sort

Excel Video 369 introduces the TRUNC function which drops everything after the decimal. TRUNC may not be quite as elegant as ROUND is, but it may come in handy for you. Watch how I combine SUM, ABS, and TRUNC in one array to calculate the sum of the absolute value of...

## Excel Video 368 Using Arrays with ABS

No, Excel Video 368 isn’t a fitness videos and arrays won’t help you with your abs. ABS is an Excel function that takes the absolute value of a cell. We’ll take the absolute value of a range of cells by combining ABS with an array today. Also watch for how I write a...