Using Aggregate to Count Visible Rows
In this post I’m going to show one of my favourite financial modeling tricks: how to use Aggregate to Count Visible Rows. Background Often, when I’m building models in Excel, I like to group key assumptions at the top of