How to create a multi level axis
In this video, we'll look at how to build a chart with multi-level axis labels. A multi-level axis allows you to group related information together...
Dave Bruns
How to add a secondary axis to a chart
In this video, we'll look at how to add a secondary axis to chart. A secondary axis allows you to data with a different scale in the same chart...
How Excel plots dates on a chart axis
In this video, we'll look at an example of how Excel plots dates on a horizontal axis, and some ways you can control the axis when working with dates...
An introduction to chart axes
In this video, we'll take a look at the different axes (horizontal, vertical, etc.) you'll find in Excel charts...
Get first entry by month and year
Note: the values in E5:E8 are actual dates, formatted with the custom number format "mmm".
Working from the inside out, the expression:
MATCH(TRUE,TEXT(date,"...Read moreValue is within tolerance
In this example the goal is to check if values in column B are within a tolerance of .005. If a value is within tolerance, the formula should return "OK". If the value is out of tolerance, the formula should return "Fail". The expected value is listed in column C, and the allowed tolerance is...Read more
Get last entry by month and year
Note: the lookup_value of 2 is deliberately larger than any values in the lookup_vector, following the concept of bignum.
Working from the inside out, the expression:
(TEXT($B$5:$B$13,"mmyy")=TEXT(E5,"mmyy...Read moreARABIC Function
The ARABIC function converts a Roman numeral to a number in Arabic numeral form. The result from ARABIC is a numeric value.
ARABIC takes just one argument, roman_text, which should be a Roman number provided as a text string. For example, the...Read more
ROMAN Function
The ROMAN function converts a number to a Roman numeral. For example:
=ROMAN(4) // returns "IV"
=ROMAN(9) // returns "IX"
=ROMAN(99) // returns "XCIX"
=ROMAN(100) // returns "C"
ROMAN takes two ...Read more
Randomly assign people to groups
In this example, the goal is to randomly assign the names in column B to three groups of equal size. The group names are "A", "B", and "C", and these values appear in the named range groups (F5:F7). The solution should automatically count the number of groups to assign and...Read more