Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Derive Excel Column Letter from Column Number

Carluccio555
9 - Comet

Hoping there is a simple-ish formula expression to accomplish this eg, if the input is '26' the output is 'Z' if the input is '52' the output  is 'ZZ'

 

Thanks

11 REPLIES 11
ChrisTX
15 - Aurora

Small correction to the helpful workflow from @AndrewDMerrill 

 

In the Generate Rows tool:
  original Loop Expression:        Floor((PreModulus)/26,1)
  corrected Loop Expression:   Floor((PreModulus)/26.001,1)

 

Column numberManually verified Column Nameincorrect Column Name from original code
52AZBZ
78BZCZ
702ZZAAZ

 

AndrewDMerrill
13 - Pulsar

Good catch, @ChrisTX !

 

Unfortunately, I think the "corrected loop expression" will provide incorrect results for absurdly large values (>26000). That being said, thanks to your insights, I was able to finally see clearly what I struggled for so long to see. I have updated the math so that the outputs match what you and now I have manually verified to be correct. This new workflow should work for every input value you can feasibly throw at it.

Screenshot.png

Labels