Difference between revisions of "Manuals/calci/LISTCOLUMNLABELS"
Jump to navigation
Jump to search
(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 ...") |
|||
Line 15: | Line 15: | ||
# 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 | # 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 | ||
# 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 | # 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 | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|v=17hHucGoWxE|280|center|Alphabet}} | ||
==See Also== | ==See Also== |
Latest revision as of 13:21, 18 March 2019
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
- LISTCOLUMNLABELS(9) = A B C D E F G H I
- 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
- 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
Related Videos
See Also
References