Count the columns between two points on a table !

General discussion on MS Excel and its spreadsheets.

Count the columns between two points on a table !

Postby Tansenn » Thu Aug 21, 2014 7:08 am

HI,

Is it possible to count the number of columns between two identified columns ? I don't 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 ?

Any idea how can i do it
Thanks in advance,
Tansenn
 
Posts: 28
Joined: Tue Mar 25, 2014 6:27 am

Re: Count the columns between two points on a table !

Postby MikeLON » Sat Aug 23, 2014 8:58 am

Hi

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

I hope this will help you.
Thanks,
MikeLON
 
Posts: 32
Joined: Tue Mar 25, 2014 6:18 am


Return to MS Excel- Help Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron