Yesterday, I covered the new BYCOL function, which allows you to perform calculations on columns in an array. Guess what? There’s also a BYROW function! Predictably, it does the same thing for rows instead. Here’s the syntax: Whereas BYCOL calculated…
The new BYCOL function is currently only available to Office Insiders, but it promises to make calculating columns easier and more efficient. The Sales by Month table contains monthly sales figures for six products. If you wanted to calculate the…
A running total is the summation of the current and previous numbers in a column. It’s a useful way of keeping track of sales figures over a time period or for monitoring the balance on a bank statement. Have a…
Star rating systems are commonly used to rank things like films, TV shows, hotels, and shopping products. Typically, they are done on a scale of 1–5 (or 0–5), although you may have seen the odd six-star hotel or 10-star energy-rated…
The RANDBETWEEN function provides a non-dynamic array solution to creating a set of random numbers. It returns an integer between the minimum and maximum values you specify. The problem is, however, it is likely to return duplicates after each worksheet…
Many Excel functions are dynamic array-friendly, meaning they are capable of returning a spilled range. This isn’t just true for newer ones such as FILTER, SORT, and UNIQUE, but others as well like MATCH, LEFT, and LEN. Unfortunately, some aren’t….
End of content
End of content
