'POWER function' category
How to use the POWER function
What is the POWER function? The POWER function calculates a number raised to a power. You can also use the […]
What is the POWER function? The POWER function calculates a number raised to a power. You can also use the […]
How to graph an equation
Why graph an equation? Graphs make it easier to analyze features of the equation like intercepts, increasing/decreasing, maxima/minima, concavity, etc. […]
Why graph an equation? Graphs make it easier to analyze features of the equation like intercepts, increasing/decreasing, maxima/minima, concavity, etc. […]
Sort based on frequency row-wise
In this article, I will demonstrate two techniques for counting per row. The first example is simple and straightforward. The […]
In this article, I will demonstrate two techniques for counting per row. The first example is simple and straightforward. The […]
Count overlapping days in multiple date ranges
The MEDIAN function lets you count overlapping dates between two date ranges. If you have more than two date ranges […]
The MEDIAN function lets you count overlapping dates between two date ranges. If you have more than two date ranges […]
Excel formula categories
AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values