Is it possible to count the columns between two points on a table?

bobsone1 · #1 08-13-2014, 02:22 AM

HI.

Is it possible to count the number of columns between two identified columns? I dont want to know whats in cells, just how many columns there are.
E.g. how many columns are between (and not including) the columns O and AS?

Regards.

whatsup · #2 08-13-2014, 10:26 AM

Hi

excel got a function COLUMN() you can use:
=COLUMN(AS1)-COLUMN(O1)

bobsone1 · #3 08-14-2014, 01:42 AM

thanks :-)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Table with varying columns in each row	norwood	Word VBA	1	05-23-2014 03:16 PM
Remove bullet points from table of contents	damo87	Word	3	12-09-2013 12:47 PM
Word table - how do I append % symbol to each value in columns 3 & 4 of a table	Dawsie	Word	4	03-06-2013 12:33 AM
Edit Points in Curve: MS Office changes points properties itself, without my action.	Sergey SPb	PowerPoint	0	08-27-2012 05:33 AM
Aligning numbered bullet points in two columns in a table	tenpaiman	Word	2	08-07-2012 06:10 PM