If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

DATA TYPES and columns headers

Thread starter DRSteele
Start date Mar 27, 2021

Overview Discussion

DRSteele

Well-known Member

Mar 27, 2021

DRSteele submitted a new Excel article:

DATA TYPES - Column title formula for cells extracted from the field selector

The new DATA TYPES in Excel for Insiders (Beta at this point) are certainly good fun. But typing in the column title for the data you've extracted from each cell is a right pain.

If you wish to select a long list of items from the field selector, you would think that you would be doomed to have to look at each cell to see what has been selected and then type it into each cell above to act as a column header. Problems arise when you later change the cell reference but fail to update the...