How to get relative column numbers in a range in Excel
This tutorial shows how to get a full set of relative column numbers in a range usingĀ an array formula based on the COLUMN function. Formula {=COLUMN(range)-COLUMN(range.firstcell)+1} On the worksheet, this must be entered as multi-cell array formula using Control + Shift + Enter This is a robust formula that will continue to generate relative numbers …