Statistics
All
RANK
6,035
of 300,853
REPUTATION
8
CONTRIBUTIONS
0 Questions
1 Answer
ANSWER ACCEPTANCE
0.00%
VOTES RECEIVED
4
RANK
17,502 of 21,094
REPUTATION
4
AVERAGE RATING
0.00
CONTRIBUTIONS
1 File
DOWNLOADS
2
ALL TIME DOWNLOADS
42
RANK
of 171,319
CONTRIBUTIONS
0 Problems
0 Solutions
SCORE
0
NUMBER OF BADGES
0
CONTRIBUTIONS
0 Posts
CONTRIBUTIONS
0 Public Channels
AVERAGE RATING
CONTRIBUTIONS
0 Discussions
AVERAGE NO. OF LIKES
Feeds
Submitted
MS Excel column from number and vice versa
Get column id from number. For example 26-'z', 702-'zz',703-'AAA', etc.. Likewise, get column number from text.
6 years ago | 2 downloads |
Answered
I need to convert a number into its column name equivalent
You can use the following functions. It works for any number. num=14558 a=num2xlcol(num) % convert number to xlcol b=xlc...
I need to convert a number into its column name equivalent
You can use the following functions. It works for any number. num=14558 a=num2xlcol(num) % convert number to xlcol b=xlc...
6 years ago | 4
