Columns between (exclusive)
?
Columns including bounds
?
Example: from B to F → 4 columns between (5 inclusive)
Recent History
How It Works
Exclusive difference counts the columns strictly between the two columns (not counting either endpoint). For example, between B and F there are 4 columns (C, D, E — wait, that's only 3). Actually: B=2, F=6, difference = |6−2| = 4 columns between them.
Inclusive count counts both endpoints: B, C, D, E, F = 5 columns. This corresponds to the width of the range B:F in Excel.
This is useful when using the OFFSET function, building dynamic ranges, or calculating column widths in VBA.