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 ...

Get Master VISUALLY® Excel® 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.