I'm trying to number a grid from 120 rows by 120 columns: horizontal ABC, vertical 123 using Algorithm ID:
Numbering vertically isn't a problem. Numbering horizontally using
is. Numbers should become characters.
char(65 + ("hor"%26)) || char(65 + round("hor"/26, 0))
thinking that if
"hor" == 13, the result should be
NA but it gives me
I cannot find out what I am doing wrong. Take a look at the table: