Tags: SUBTOTAL

Display auto filter criteria in a cell

{ 2 Comments }

Assume data in range D6:E11 – months in D6:D11 and numbers in E6:E11.  Headings are in D5:E5.  On filtering multiple values in column D, one may want to view the filtered criteria in cell (separate criteria by comma for multiple selections in auto filter drop down). For solving this problem, you will have to download and install the morefunc […]

Read More →

Compute Day Sales Outstanding (DSO)

{ 46 Comments }

A financial concept, Day Sales Outstanding (DSO), is a measure of the average number of days that a company takes to collect revenue  after a sale has been made.   For further clarification, read here. Herein, i have presented the solution for two different data layouts.  Further, Layout 2 has two further divisions – one for computing […]

Read More →

Apply the SUMPRODUCT() function on the visible cells of a filtered range

{ 0 Comments }

The SUMPRODUCT() function works on all cells in the specified range – whether filtered or not.  However, one may want to apply the same function on the visible cells of a filtered range. You may refer to my solution in this workbook.

Read More →