Count Column Difference
 

Is there a function which could give me difference

e.g. if I am in cell G5, is there a function which would return me the
count it is away from say D5 such as

function (G5:D5) = 3 (the column G is 3 cell away from column D)

alternatively if there is a function which could return the current
column (in number G5-7, D5-4) !!

Thanks for your help!

Kind regards,
Raj

Count Column Difference
 

Column difference:
=COLUMN(G5)-COLUMN(D5)

Current Column Number:
=COLUMN(G5)
=COLUMN(D5)

*** Please do rate ***


"Raj" wrote:

Is there a function which could give me difference

e.g. if I am in cell G5, is there a function which would return me the
count it is away from say D5 such as

function (G5:D5) = 3 (the column G is 3 cell away from column D)

alternatively if there is a function which could return the current
column (in number G5-7, D5-4) !!

Thanks for your help!

Kind regards,
Raj

Count Column Difference
 

alternatively if there is a function which could return the current
column (in number G5-7, D5-4) !!

In any cell:
=COLUMN()
will return the col # of that cell
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---