Chapter 14. Applying Reference, Information, and Text Formulas
Determine the Number of Columns in a Selection
You can use the COLUMNS function to determine the number of columns in a range. For example, suppose you keep a worksheet that contains name and address information for the members of a club, along with other miscellaneous information about each club member. You might want to use the COLUMNS function to determine the number of columns in your worksheet that contain membership information.
The COLUMNS function can also be very useful if you assigned a name to a range and you want to determine the number of columns in the named range; the COLUMNS function makes it very easy to determine this information.
You might also want to use the number ...