According to this topic: How to convert a column number (e.g. 127) into an excel column (e.g. AA)
I don't understand what is in algorithm: here
Could someone explain me, what is happening in a while loop?
Asked
Active
Viewed 74 times
1 Answers
1
It is, in effect, "converting" the column number to base 26, where the "digits" are the letters A..Z.
For example, for column 720:
modulo= (720-1)%26 = 17columnName= 'R'dividend= (720-17)/26 = 27modulo= (27-1)%26 = 0columnName=A+columnName=ARdividend= (27-0)/26 = 1modulo= (1-1)%26 = 0columnName=A+columnName=AARdividend= (1-0)/26 = 0
Resulting in AAR.
Scott Hunter
- 48,888
- 12
- 60
- 101
-
Ok, but why we subtract one from a number in modulo? – Prezes Łukasz Sep 15 '16 at 16:03
-
To account for the first column being 1. – Scott Hunter Sep 15 '16 at 16:16
-
I don't understand... When we have e.g. 720, and we subtract 1, the result is 719 and what this gives us? Why don't we do 720 % 26? – Prezes Łukasz Sep 15 '16 at 16:18
-
Column 1 should map to A; if you don't subtract 1, it would map to B. – Scott Hunter Sep 15 '16 at 16:50
-
I still don't understand :( Why should map to A and how you see that subtract one map to A? – Prezes Łukasz Sep 15 '16 at 19:17