Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

=COLUMNS({1,2,3;4,5,6}) returns the number of columns in the array constant

Input the formula: =COLUMNS({1,2,3;4,5,6}). Press Enter to get the result.