One reason I like the N function is because it is Excel’s shortest function name. But it has quite a few useful features as well.
Monthly Archives: April 2022
Last used column number in a row in Excel
AGGREGATE to the rescue
A while back I posted a formula to find the row number of the last used cell in a column. I revisit the solution to provide the last used column number in a row.
Excel Power Query and Multiple Files 2022
Webinar recording from April 12, 2022
This is the recording of the second free Power Query webinar I ran in 2022.
You can watch the first one at this link.
In this session we see how to import multiple files in one Power Query. We look at importing CSV and Excel files.
You can download the materials, including a detailed pdf manual using the button below.
Removing Outliers in Excel
Dynamic array solution
I wrote a blog post a while back about outliers and Excel and I thought I would revisit it thanks to dynamic arrays.
One Minute to Excel #25 – Find the breakeven point
Goal Seek solution
If we have a simple Profit and Loss and we want to figure out a breakeven point, we can use Goal Seek to find it.
We can also use it to see sales required to meet a certain profit.
All in less than in minute.
Capture an AutoCalculate Value in Excel
A new feature
A recent update to Excel has made a slight change to the AutoCalculate feature. You can copy a value by simply clicking on it.