There are times where you may wish to report sub groups within departments. It can be difficult when the sub groups are varying lengths. Here is a solution to that problem. The formula will test for the first item in the sub group and return a result, then test for a second sub group and if found return a result.
The formula is as follows.
The Tennis Chart July 17, 2019
Smallman Interview July 15, 2019
Excel Summit South 2019 July 12, 2019
Sales Excel Dashboard June 14, 2019
Using the Wildcard with SUMPRODUCT May 30, 2019
Excel Dashboard by City May 16, 2019
Excel Timesheet Example May 9, 2019
When TRIM Doesn't Work in Excel May 8, 2019
Excel Now Has 3D Pictures May 1, 2019
Using Index as a Dynamic Range April 30, 2019