Manuals/calci/LISTCOLUMNLABELS

Revision as of 16:41, 27 December 2017 by Devika (talk | contribs) (Created page with "<div style="font-size:30px">'''LISTCOLUMNLABELS (Num)'''</div><br/> *<math>Num</math> is any real number. ==Description== *This function shows the list of alphabets for the ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
LISTCOLUMNLABELS (Num)


  • is any real number.

Description

  • This function shows the list of alphabets for the given numbers.
  • In  ,  is any real number.
  • For this function ,will show the alphabets in its order.
  • For the numbers up to 27,this will show the alphabets a to z.
  • After 27,this will show the two alphabets like AA,AB,AC and so on.
  • Then after completion of two alphabets then this function will take three alphabets and so on.

Examples

  1. LISTCOLUMNLABELS(9) = A B C D E F G H I
  2. LISTCOLUMNLABELS(30) = A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD
  3. LISTCOLUMNLABELS(80) = A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ BA BB BC BD BE BF BG BH BI BJ BK BL BM BN BO BP BQ BR BS BT BU BV BW BX BY BZ CA CB

See Also

References