This example illustrates how to use the union and intersect operator (borders below for illustration only) in Excel.
1. The union operator (comma) adds two ranges.
Explanation: the SUM function reduces to =SUM(C4:D8) + SUM(D7:E11), 20.
2. The intersect operator (single space) returns the intersection of two ranges.
Explanation: the SUM function reduces to =SUM(D7:D8), 2.
.
Use flash fill in Excel 2013 or later to automatically extract or combine data.Extract1. For example, use flash fill to extract the numbers...
Use the 'Paste Special Skip Blanks' option and Excel will not overwrite existing values with blanks.1. Select the range B1:B12.2. Right...
Sometimes it can be useful to hide columns or rows in Excel.HideTo hide a column, execute the following steps.1. Select a column.2. Right...
You can insert a comment in Excel to give feedback about the content of a cell.Insert CommentTo insert a comment, execute the following...
It's easy to create all sorts of sequences in Excel. For example, the Fibonacci sequence.1. The first two numbers in the Fibonacci sequence...
