PIVOTBY is great for analysis, but PivotTables still have the edge when formatting needs to adapt to data changes.

The FORMULATEXT function is often dismissed because it merely transforms a formula into text. However, that raw text is exactly what makes it so valuable. So, stop thinking of it as a one-trick ...

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight the top ...

If I enter the following: =CONCATENATE("Design Avg. Flow per Cell = ",J12," g.p.d. / ",J21," Cells") where J12=6300 and J21=3, I get Design Avg. Flow per Cell = 6300 g.p.d. / 3 Cells Is there some ...