Thread: inverse of the column function? i.e. input a number, output thecorresponding column text label
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default inverse of the column function? i.e. input a number, output th
Thanks Guys!!!


Cheers,
Shane Devenshire


"Glenn" wrote:

Rick Rothstein wrote:
2007:
=LEFT(ADDRESS(1,A1,2),1+(A126)+(A1702))

2003:

=LEFT(ADDRESS(1,A1,2),1+(A126))

Nice going Shane... I would definitely call these formulas the "elegant"
ones the OP was looking for.

Rick


Agreed!

Reply With QuoteReply With Quote