Excel Tips
Using SEQUENCE Inside Another Function »
August 24, 2022
Say that you want to figure out how much interest you will pay in year 3 of a loan. You don't need to create a loan amortization table to do this.
Generating a Range of Sequential Numbers »
August 22, 2022
I have a cool trick in my Power Excel seminars where I show how you can Ctrl + drag the fill handle from a cell with the number 1, and Excel will extend to 2, 3, 4.
Nesting Array Functions: SORT, UNIQUE, and FILTER »
August 19, 2022
Say that you want to filter the names in a column so you get just the unique rows sorted where the team in the other column is Blue.
Syntax of the UNIQUE Function »
August 18, 2022
The new UNIQUE function is part of the Dynamic Array formula collection. It returns the distinct values from an array.
Using FILTER with Multiple Conditions »
August 17, 2022
Say you have to combine two criteria, and both criteria have to be true. Wrap each item in parentheses and multiply them together.
Using The FILTER Function With One Condition »
August 16, 2022
The new FILTER function accepts an array, keeps the rows you specify, and returns the results to a spill range.
A Random Sort Using SORT and RANDARRAY »
August 15, 2022
Difficult scenarios like random drug testing and random with no repeats become mind-numbingly simple when you combine SORT with RANDARRAY.
A Simple Sort with One Argument »
August 12, 2022
Sorting with a formula in Excel used to require an insane combination of formulas. Take a look at the data, which is used throughout this example.
What Happens if A Formula can't spill? »
August 11, 2022
What if we put some stuff in the way and enter one of the Dynamic Array formulas, what will happen? You will get a #SPILL! error.