G GN0001 Member Feb 26, 2011 #1 =Column(B2:L2)results 2. While between B2:L2, We have a bunch of columns. Can anybody explain it what the reason is? Regards, Guity
=Column(B2:L2)results 2. While between B2:L2, We have a bunch of columns. Can anybody explain it what the reason is? Regards, Guity
Hui Excel Ninja Staff member Feb 27, 2011 #2 Guity Column is returning the value 2 for column B, the first column in your range To count the number of Columns in your range try =Columns(B2:L2)
Guity Column is returning the value 2 for column B, the first column in your range To count the number of Columns in your range try =Columns(B2:L2)
