by Nate Moore | Jul 29, 2013 | 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...
by Nate Moore | Jul 22, 2013 | Arrays
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...
by Nate Moore | Jul 15, 2013 | Arrays
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...
by Nate Moore | Jul 8, 2013 | Arrays
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...
by Nate Moore | Jul 1, 2013 | Arrays
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...
