Thread: inverse of the column function? i.e. input a number, output thecorresponding column text label
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default inverse of the column function? i.e. input a number, output the corresponding column text label
Otherwise, this same approach gets more complicated (for columns above Z)

=IF(A126,CHAR(INT(A1/26)+64),"")&CHAR(MOD(A1,26)+64)

This one fails for a value of 26 (it returns "@" instead of "Z"). I ran into
the same problem while developing my 2nd posted solution.

--
Rick (MVP - Excel)

Reply With QuoteReply With Quote