A personal repository of random information in compensation for a fatigued biological computer
Breaded IT » MS Access / SQL Server reminders » MS Excel 2003: Dynamic Named Range
Start cell is named OverviewSeriesStart,
Looks maximum of 50 entries down
=OFFSET(OverViewSeriesStart,0,0,COUNTA(OverViewSeriesStart:OFFSET(OverViewSeriesStart,50,0)),1)