Jump to content

  • Log in with Facebook Log in with Twitter Log in with Windows Live Log In with Google      Sign In   
  • Create Account

Submit your paper to J Biol Methods today!
Photo
- - - - -

Column number code of EXCEL


  • Please log in to reply
2 replies to this topic

#1 Inmost sun

Inmost sun

    Veteran

  • Active Members
  • PipPipPipPipPipPipPipPipPipPip
  • 302 posts
60
Excellent

Posted 10 November 2012 - 07:27 AM

Excel uses a triple letter code to specify columns;

does anyone know a system or formula to transfer such code to a real number;

f.i. "ATE" means which number?

thanks for assistance in advance

Edited by Inmost sun, 10 November 2012 - 07:28 AM.


#2 pcrman

pcrman

    Epigenetist

  • Global Moderators
  • PipPipPipPipPipPipPipPipPipPip
  • 1,165 posts
67
Excellent

Posted 10 November 2012 - 09:25 AM

I guess you need a simple script to convert the alphabetic code to numeric.

ATE = (26 x 26 +1) + (26 x 20) + 5 = 1202 (I hope my calculation is right)

another example:
IV = 265 = 9 x 26 + 22 = 256

You can do it directly in Excel if you are using Excel 2007 or above. See this video


#3 Inmost sun

Inmost sun

    Veteran

  • Active Members
  • PipPipPipPipPipPipPipPipPipPip
  • 302 posts
60
Excellent

Posted 15 November 2012 - 12:07 AM

thanks pcrman, very helpfulPosted Image;

but I think there is a slight mistake in your formula:

You wrote:
ATE = (26 x 26 +1) + (26 x 20) + 5 = 1202


but I think it must be:
ATE = (26 x 26 x 1) + (26 x 20) + 5 = 1201

Edited by Inmost sun, 15 November 2012 - 01:30 AM.





Home - About - Terms of Service - Privacy - Contact Us

©1999-2013 Protocol Online, All rights reserved.