Count Column Difference  
Author Message
mitsirrah





PostPosted: Mon Aug 28 00:46:01 CDT 2006 Top

worksheet functions >> 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

Excel344  
 
 
Naveen





PostPosted: Mon Aug 28 00:46:01 CDT 2006 Top

worksheet functions >> Count Column Difference Column difference:
=COLUMN(G5)-COLUMN(D5)

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

*** Please do rate ***




> 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
>
>
 
 
demechanik





PostPosted: Mon Aug 28 00:54:01 CDT 2006 Top

worksheet functions >> 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
---