Dynamic Column Name Identifier Formula (USING MOST RECENT VERSION OF OFFICE 365)

bondtoo7

New Member
Joined
Mar 31, 2016
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
File: Dynamic Column Identifier Formula.xlsm

I created this formula to dynamically return the column name based on the corresponding column number. That said, it works intermittently once you get to Column AA. I could understand if it was broken completely at Column AA and beyond, but I cannot figure out why it works at times and not at others. Any help would be greatly appreciated!

-Tyler
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,317
Office Version
  1. 365
Platform
  1. Windows
Not entirely sure where you are going with that formula, but why not just use
=SUBSTITUTE(ADDRESS(1,A1#,4),1,"")
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,232
Office Version
  1. 365
Platform
  1. Windows
Tyler

There's no formula in that workbook, at least when it's viewed online.
 

bondtoo7

New Member
Joined
Mar 31, 2016
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Not entirely sure where you are going with that formula, but why not just use
=SUBSTITUTE(ADDRESS(1,A1#,4),1,"")

Awesome, this worked perfectly! I am brand new to the new formula engine in Excel, so I am not familiar with the "#" in the column reference of you address formula. I'm assuming that triggers the spill function? Thank you for the speedy response, this is excellent!

Have a great day :)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,317
Office Version
  1. 365
Platform
  1. Windows
The # indicates that A1 is the first cell in a spill range & so the formula will spill as far as there is data in col A
 

Watch MrExcel Video

Forum statistics

Threads
1,123,385
Messages
5,601,331
Members
414,446
Latest member
CRAVIN

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top